display userform a certain time of day?

A

Anthony

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display userform at certain time 2
how to reshow userform after following a link 1
change the appearnce of a userform 2
Hiding a "Userform" instead of closing it??? 3
If no activity, display a UserForm; 10 seconds later close Workboo 4
Excel data display userform problem 3
Loading UserForm Controls (with a twist!) 5
Pasting a date to a cell from UserForm 2

Top