form open close

[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

 

[Ken Snell [MVP]]

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.