View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default 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