Macro based on populated field

S

Susan

Recently someone ask, and was answered, how to run a macro
dependant upon another populated field within that form
(i.e. "if this field is x then run this macro otherwise
run this other macro"). How would one do it if what one
wanted was "if this field is x then run this macro,
otherwise do nothing"?

Thanks in advance
 
T

tina

the "Else..." argument of an If statement or IIf() function is optional.
just don't include it.
 
S

Steve Schapel

Susan,

Just put the equivalent of...
[TheOtherField]="x"
.... in the Condition of the relevant macro action. That's all. There
is no need for any "otherwise do nothing" consideration to be applied.
If the Condition is met, the macro will run, if it's not, it won't.
 

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

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
VBA word change keys 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
ASK Field Formatting 1
How do I clear a form? 0
Page numbering with Merged Document and IF statements 1

Top