form open close

  • Thread starter Thread starter DD
  • Start date Start date
D

DD

i have a macro that opens a form runs the macro then closes the form. the
form displays a message. sometimes it runs so quick you can't read what the
form says. is there a way to put a pause statement in for 5 seconds or so
so the user can read the message.

thanks
 
Split the macro into two macros.

The first macro should open the form, and then stop.

The form's Timer Interval should be set to 5000 (equivalent to 5 seconds).
Use the form's Timer event to run the second macro, whose first step must be
to set the Timer property of the form to 0 (use SetValue action), and then
its next steps would be all the other steps that your current macro is
doing; the last step in this second macro should be to close the form.
 
Back
Top