I have a sheet called 'Print' in my workbook. There are three modules, and they contain three different 'macros'. Cell 'C8' of this sheet has a drop-down list. This drop-down list has three items named 'One', 'Two', and 'Three'. Cell 'D8' of this sheet has a button called 'Run'. I want to assign a macro to this button, which will execute 'Macro1' if the "Run' button is clicked in cell 'D8' after selecting 'One' in cell 'C8'. After selecting 'Two' in cell C8, clicking the "Run' button in cell 'D8' will execute 'Macro2'.
Thus, 'macro3' will run for 'three' selections.
Is it possible to do this without any worksheet event code?
Can anyone help me with this?
Bookmarks