Date / Time + Prompt

thorpyuk

Well-known Member
Joined
Mar 14, 2006
Messages
1,453
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!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

thorpyuk

Well-known Member
Joined
Mar 14, 2006
Messages
1,453
does anyone know of a clock control I can use anywhere?
Should I just have a data validation time in a cell dropdown?
 

thorpyuk

Well-known Member
Joined
Mar 14, 2006
Messages
1,453
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!
 

Forum statistics

Threads
1,181,649
Messages
5,931,216
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top