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

Look at OnTime, http://www.cpearson.com/Excel/OnTime.aspx

--
__________________________________
HTH

Bob

"Anthony" <(E-Mail Removed)> wrote in message
news:23D381C6-5293-4C8C-A0AF-(E-Mail Removed)...
> 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