macro within a macro

  • Thread starter Thread starter Jim Bohnet
  • Start date Start date
J

Jim Bohnet

I want to have a macro which looks at the results in a
particular cell. If the cell says "yes", then the macro
should select a specific named range in the worksheet and
print it. But if the answer is "no" or the cell is blank,
then a different named range should be selected and
printed. I tried setting up two print macros - 1 for each
range. I then wanted to have a macro button that executed
an if statement to select which range to print, but
couldn't make this operable. Does anyone have a way to
accomplish this selected area printing- either with or
without macros??
 
If you set up a control text box (could be invisible) that
is linked to the cell in question, then you can use the
result of the cell (the name of the text box control) in
your macro if statement (no special syntax, just type the
name of the control box, default name is probably text box
or combobox if you select a combo box control).

Good luck and feed back if you need more help.
Ski
 
Back
Top