Not sure if this is what you are looking for:

Public Sub LoopMacro()

LoopMacro.Show vbModal

End Sub


HotRod wrote:
This goes with my question below but. I want to launch a "loop" macro when
the excel sheet is opened to monitor the time and then run another macro
when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
Also is there a better way to monitor the time than in a WHILE < Loop?