Macro Stop

  • Thread starter Thread starter Jwebb
  • Start date Start date
J

Jwebb

In a form.... I would like a macro to stop if a text box
is blank is left blank. After the macro stops I would
like a pop up box to let the operator know they have to
fill out the text box or they will not be able to process
the rest of the macro. If the box is filled out then the
macro will run uninterupted.

TFTH,
Josh
 
Josh,

Use Conditions for the macro actions. If you can't see a Condition
column in the macro design window, select it from the View menu. You
could do it like this...
Condition: [NameOfTextbox] Is Null
Action: MsgBox
Message: Entry required in textbox
Condition: [NameOfTextbox] Is Not Null
Action: <your other macro functionality>
 
Back
Top