option button help please
see if i can explain what i want to accomplish:
i have data validation dropdowns in a2 and a3, starting month to ending
month, to run a report
i have 3 option buttons, depending on the report to run
i was wondering if there was a way to run whatever optionbutton code that
was last selected
when the value in a3 changes.
right now, when i change the month in a3 and i want to run the report i just
ran with different dates, i have to click one of the other option buttons
and
then come back and click the option button i want.
i thought a worksheet change will do, and i can check to see what option
button was last selected, but i don't know how to run its associated
code..
--
Gary
|