Time Management Tool

**EJensen** · 05-02-2009, 02:55 PM

I have 143 macros, but I put 8 of them here b/c the post would not go through with all of them. I couldn't fit all of them on an attachment either b/c the file size was too big. However, I have this goal I have been working on for the last three months on the weekends and the last part I need some help with. I would like help with a macro that I can add onto the ones I have. I would like the macro to activate and cause a message box to appear when I open the excel doc. I would like also to be able to activate the message box and its associated macros after the document has been opened.

I would like the message box to have
- Message “The Current Time is (Macro puts current computer time here)”
- Question “How much time do you have?” then beneath this question
- Blank field labeled Hour to give answer
- Blank field labeled Minute to give answer

Depending on the current time on the computer as well as the hour and minute entered, a macro with a matching title from the list below will be selected that fits that criterion. For example, let’s say it is 5:30am and I entered 1 hr and 15 min in the empty fields of the message box. As a result the macro named “Sub Hour1Min15time530am” will be activated. Also due to the fact that the macros I have are in 15 min intervals the code would need to round to the nearest time, so if it was 5:33am when I ran the code the macro would default to 5:30am whereas if it was 5:39am when I ran the code the macro would default to 5:45am. Is this possible to do and if so could you help me with it?

Please Login or Register  to view this content.

**antoka05** · 05-02-2009, 03:37 PM

What you need may be not a problem but please attach your worksheet (columnS B..L or also b:c) to better understand what cells formula refers to dependending on start and entered time so it's possible to do all in a shorter macro.

Regards,
Antonio

**DonkeyOte** · 05-02-2009, 04:09 PM

Just as a heads up - this:

Please Login or Register  to view this content.

can be shortened somewhat to:

Please Login or Register  to view this content.

I suspect you could adapt you other code along similar lines...

Try to avoid lots of .Selects as this will slow your code

**EJensen** · 05-02-2009, 07:51 PM

I attached the Excel doc here per your advice. Thank you for your help. I was surprised to see that I was able to attach it. I tried attaching a word doc with all the macros with my first post but it said the file was too big. I am happy I was able to get it here so you can get a better idea of what I am talking about. Thank you.

**EJensen** · 05-02-2009, 07:53 PM

Thanks for the tip DonkeyOte, I can't believe I overlooked your suggestion. I could have saved myself a lot of time. I will keep in mind to avoid using lots of .Selects. Thanks again for your help.