Run different Macro based on cell value

[Kevin Rush]

Is it possible to select a marco based on cell value? Or have a macro check the value of a cell and then act based on that value?

I have have 2 similar macros that will print sheets to PDF. However, I would like to use just one button to run these.

Example, if Cell B10 of sheet 1 contains a value of less than 25 I would like it to print sheets 4 & 5. If the Cell B10 of sheet one contains a value of more than (or equal to 25) then I want it to print sheets 6 & 7.

I already have the Print PDF script.

Thanks

[TMS]

Maybe something like:

Please Login or Register  to view this content.

Macro45 would run your print pdf code for pages 4 and 5, and Macro67 would …, well, you get the drift.

[Kevin Rush]

Great, thanks. I’ll try that. I assume that I can just number my macros however I like?

[TMS]

I assume that I can just number my macros however I like?

But of course; it was just for the purpose of making an example.

[Kevin Rush]

Worked perfectly, Thank you!

[TMS]

You're welcome. Thanks for the rep.