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 = InputBox("Enter Date")
<Do something with Date entered by op>
End If
You may want to error trap for a non-date entry.
Regards - Dave.
Date: Thu, 16 Apr 2009 10:33:09 +0530
Subject: $$Excel-Macros$$ Re: Message Box
From: [email protected]
To: [email protected]
u can use input box for entring a date while running macro
On 4/16/09, Steve <[email protected]> wrote:
Hi,
I need to insert a message box in the middle of a macro that will
request the user to enter a "Start Date" or give them the option to
skip it and
let the macro continue running. Any help would be deeply appreciated.
Thanks,
Steve
--
Regards
Darshan Amreliya
Sr Engineer
Ispat Industries Limited
Cell No 09321063681
_________________________________________________________________
Looking to change your car this year? Find car news, reviews and more
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
If you find any spam message in the group, please send an email to:
Ayush Jain @ [email protected] or
Ashish Jain @ [email protected]
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
