Hold VBA execution until form closes

  • Thread starter Thread starter Duncs
  • Start date Start date
D

Duncs

I have a form with an OK button, which shows an error message. (I
used this rather than the MsgBox, as I wanted more control over what
is displayed.)

What I need to know is, how do I hold the execution of the VBA code
until the OK button is clicked?

TIA

Duncs
 
Open the "OK button" form in Dialog mode; all code stops except for the code
running in that form until that form is closed or made invisible.
 
Back
Top