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

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