Macro Stop

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
 
S

Steve Schapel

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top