Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display userform a certain time of day?
Hi all,
I have a userform named sweepcheck The program that it is attached to is used from around 0430 - 2300 each day I want the userform to be displayed once the time 1100 has arrived. The user then has two options to chose from the userfrom, if YES is selected another form is activated and a series of events are run. What I would also like is if the user clicks on the NO option the userform is closed but then displayed again 1 hour later. Again once displayed if the user choses the No option it is closed and redisplayed 1 hour later This loop is repeated throughout the day until the user selects YES and is also repeated each fresh day. Hope I have explained that ok and hope somebody can help many thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
display userform a certain time of day?
Look at OnTime, http://www.cpearson.com/Excel/OnTime.aspx
-- __________________________________ HTH Bob "Anthony" wrote in message ... Hi all, I have a userform named sweepcheck The program that it is attached to is used from around 0430 - 2300 each day I want the userform to be displayed once the time 1100 has arrived. The user then has two options to chose from the userfrom, if YES is selected another form is activated and a series of events are run. What I would also like is if the user clicks on the NO option the userform is closed but then displayed again 1 hour later. Again once displayed if the user choses the No option it is closed and redisplayed 1 hour later This loop is repeated throughout the day until the user selects YES and is also repeated each fresh day. Hope I have explained that ok and hope somebody can help many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display a Chart in a userform | Charts and Charting in Excel | |||
display userform at certain time | Excel Worksheet Functions | |||
Can't Display Userform | Excel Programming | |||
display userform | Excel Discussion (Misc queries) | |||
How to cause userform to display | Excel Programming |