automatically close UserForm at ..... PM

[Sahak]

Hi all,

I did search on line & found how automatically close UserForm after some time period, but I need to close it at “x” time, for example at 10:00 PM (Unload UserForm1) & activate it next day morning for example at 6:00 AM (UserForm1.Show)

Thank you in advance

 

[Sahak]

Please, is it possible or no?

 

[mikerickson]

Have you looked at the OnTime method?

 

[Sahak]

Thank you very much for reply.

I have some idea abut OnTime method, but I’m not sure where should I put macros.
To activate UserForm:

Application.OnTime TimeValue("6:00:00"), "UserForm_Menu_Show"

to close UserForm:

Application.OnTime TimeValue("22:00:00"), "UserForm_Menu_Unload"

Cold you please help me with this?

 

[xenou]

They would go in the workbooks Open Event.

 

[Sahak]

Xenou, Thank you very much.