VBA code to show to message box between time range
Dear all,
This forum has made me to learn lot of new things.Thanks 4 everyone.
Now, Please give me a VBA a code to POP UP a Msgbox if the user is trying to run the macro between a time range of 2PM to 4.30PM everyday.
Try to put it in IF statement, if its between the above time range, then it must pop up the msgbox and exit the sub.Else it must run the rest of the code below.
Thanks for all the support...
Try this in your macro
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
This works...Thanks...
I know I have marked this thread as solved, but still I raising one more query...What will be the code if want this message box to pop-up on some specific days only.?? Say if date is between 15th to 20th of every month (irrespective of year) and time between 2PM to 4.30PM...
Plz provide me the code...
Last edited by mchilapur; 01-15-2015 at 08:31 AM.
You could try this
If Time() > 14 / 24 And Time() < 16.5 / 24 And Day(Now()) >=15 And Day(Now()) <= 20 Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks