This macro is a worksheet level macro and therefore does not show up in the macro name dialogue box (Alt + F8).
This macro will fire once you select from the data validation in B2.
If you want to run this macro thru the press of a button...
Copy the macro below...
Paste code in a Normal module - Where to paste code
- Alt + F11 >> opens the Visual Basic Editor (VBE)
- Ctrl + R >>opens the Project Explorer (if not already open on left side of screen
- Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Back in Excel >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run
After you've tested it this way, now place a button on the sheet via the developer tab >> Controls >> Insert >> Button
Now attach the code to this button
Bookmarks