Hi
Try this in your code:
Do until IsDate(Answer)=True
Answer = InputBox(Message, "Date")
If IsDate(Answer) = False Then MsgBox ("Use a standard Date format - eg
5/10/08")
Loop
Remove the line I've highlighted below in red, and replace with the above.
Regards - Dave.
>
> Sub
There's all sorts of levels of automation for this.
What email program are you using?
What is the source of the content of the email?
for instance...
If you run it all from the spreadsheet,
you could create a VBA application that CREATES the emails from data in the
spreadsheet.
That way, you alr
Hello,
At work I am confrontated with the situation mentioned below:
1. From approx. 35 countries mails are sent with a figure (one number)
of the revenues on a weekly basis
2. The mails are logged for tracking purposes
3. From the mails a number in the message body is entered manually in
a spre
Thanks a lot bala i like the way you this
i wanted a solution for you , in vba if we got alertbox in webpage
everything got stop i wanted to get the text on the alertbox and skip
that as well
please provide me help on this
thanks
regards
Santosh Bahuguna
On 4/15/09, bala wrote:
>
> Hi,
>
>
If you dont have to make any changes you paste special the file before
you move it from main file
Regards
Santosh Bahuguna
On 4/16/09, Mudassar Ramzan wrote:
> Your can use find & replace option to replace formula.
>
>
> Thanks & regards,
>
> || Mudassar Ramzan | MIS Officer | WorldCALL Telecom
Dave,
The following seems to work from your suggestions. How would I go
about putting at trap in there to make sure I get a date entry in that
cell?
Thanks,
Steve
Sub Est_New_Project_Start_Date_InputBox()
'
' Est New Project Start Date InputBox Macro
Sheets("Sheet1").Select
Range("A1").Sel
Further news.. Ok, the scoring is now working but there is an
exception to this.
Ultimately what I need solving is..
There are questions on the sheet with more than one set of options,
how can I get the lowest score from both sets of options to populate
the results field?? e.g.
Dear Mudassar,
Find n replace is not possible as the formula is different and it cant be
replaced. Also if we cut the sheet n copy to another file than the formula
shown is different. we have to once again use the vlookup to the concerned
pivot and than paste it to 250 locations.
thanks for the r
Ok scrub this I have got it working now for all cells, except for the
part that updates the number in column I. So depending on the column
selected it needs to go to the row with the score on to select the
score.
Please see new macro,
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Rang
Thank you. I'll give it a try when I get to work this morning.
Regards, Steve
On Apr 16, 2:30 am, Dave Bonallack wrote:
> Hi Steve,
>
> I think the simplest way would be a two-step approach, something like:
>
> A = MsgBox("Do you want to enter a date?", vbYesNo)
>
> If A = vbYes Then
>
> B =
Hi,
I have a worksheet which operates as a questionnaire with scoring
cloumns. I have managed to write a macro that will change the colour
of the cell upon double clicking however I'd also like to do a few
more things that with my VB knowledge I'm unable to code.
What I'd like to happen is,
- s
Paul,
Thanks for the swift response, found a simple workaround, user
error ;-))
On Apr 15, 4:57 pm, Paul Schreiner wrote:
> First of all, we'd need to see the code to give an accurate assessment.
> There are several techniques that can be used to change the cell height.
> The technique you se
SOLUTION ATTACHED
On Mon, Apr 13, 2009 at 5:24 PM, Lavprasad Kori wrote:
>
> Dear Friends,
>
> I am downloading the employee data from our portal. In, there is employee
> name & Emp. ID both are in the same column. I want to split Emp. Name & Emp.
> ID in to two different column. I am also attac
13 matches
Mail list logo
