If time is 8am to 1pm then run macro1 otherwise run marcro2

[HaroonSid]

hi,
i want to run my macro according to time change

i need if the time is 8am - 1pm and 4pm - 5 pm then run macro1 otherwise run macro2


thank you

[leelnich]

Hi HaroonSid- Try this:

Please Login or Register  to view this content.

You didn't say HOW you wanted the TEST triggered. Workbook_Open, Workbook_Save, and Worksheet_Change are some of the events you could use, or you could trigger it manually from a button, or from other code. Lots of options. Let me know if you need me to fine tune the code.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[HaroonSid]

Thank you leelnich

i will try this surely

[HaroonSid]

its working perfect

[leelnich]

Great! Glad I could help, thank you for the rep.