Time Tool New

I have an application that I attached to this post, which I have been working on, for the last four or months, in my free time on the weekends and the last part I need some help with. The doc has been updated with new macros and a chart.

I would like help with a macro that I can 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. If you look on Sheet1 of the attachment you’ll get an idea of where I am trying to go with the message box. I would like it 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 (each macro includes a time, hour, and minute in its Sub name) a code in VBA 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. You’ll see time controls at the bottom of the application. If I can get the code I am looking for those are going to be removed.