option buttons

  • Thread starter Thread starter janet
  • Start date Start date
J

janet

is there anyway of assigning a macro to an option button?

depending on the option button selected, I want different
worksheet to become active
 
Janet,


Place your buttons on a worksheet and right click each and assign the
following code

Sub OptionButton2_Click()
Worksheets("sheet2").Select
End Sub

attach the code to each button and change the name of the sheet you want to
be active for each button

Mike
 
Back
Top