Hi mc84excel,
Thanks a lot for your response. I am a novice when it comes to VBA, can you please elaborate, how can I ask the user for the date in the early part of the sub and how would I set the reply to a variable?
Highly appreciate your help.
Thanks... Murtaza
By using an InputBox (which you would need to validate the users input to prevent them entering non-dates) or by using a Date Picker as I said.
I never use an InputBox for dates so I can't help you with that, I always use a Date Picker. Demo attached FYI. However the DatePicker method is far more advanced for a novice.
Maybe someone else can explain to you how to get a date using an InputBox.
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks