View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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