Popup Q/A Box when Macro starts

[bdb1974]

Hi all,

I would like to have a question box pop up w/Yes and No Buttons at the start of my macro to choose between two different sub routines.

Therefore,

MsgBox would say: Import New Yard Inventory?
If Yes,
then it would run the alternate subroutine.
If No, Then it would run macros normal routine.

Not quite sure how to do this. Would the msg box have to be a form box
where, a representive value would have to get filled into a cell? Then
reference if cell value is true ,then

or would it register the value to memory so then, the code would have to
to call the given value then run code if value it true?

I hope even with my lack of correct terminology, that my description is sufficient to convey my problem.

Thanks,

bdb

[Paul]

Hi BDB,

You could use something like the following to determine which routine to run:

Please Login or Register  to view this content.

Clicking Yes to the message box triggers macro1, while clicking No triggers macro2. Clicking Cancel ends the code altogether.

Hope that helps!

[JBeaucaire]

Something like this:

Please Login or Register  to view this content.

Insert your macros into the colored sections.

[bdb1974]

Great!

Thanks Guys, both work.

Thanks for the options.


BDB