Date / Time + Prompt

[thorpyuk]

Hiya,

I'm trying to add in a neat callback feature into a spreadsheet i'm creating.

What I want to do is to let the user select a date, and a time to call the customer back, and then record this into a list of callback times...

Then, in addition, if the 'callback time' = now, then create a prompt for the user to call the customer back.....

I've done all the code to bring the customers details into the sheet, and i've added the calendar object, but cant find a 'clock' object...

Can anyone help with an idea, or know of an easy way of selecting a time? Also, for having the prompt sppear (or any of the above?)

Thanks!

 

[thorpyuk]

does anyone know of a clock control I can use anywhere?
Should I just have a data validation time in a cell dropdown?

 

[thorpyuk]

I've done some searching, and it seems I may need the application.ontime vba code..... I am going to have a msgbox popup when time now() = time for callback BUT

I will be working within the workbook, but not necessarily on the worksheet that will store the date / time.

Please help!

 

[thorpyuk]

*Hump*