option buttons

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
 
M

Mike Hughes

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
 
Top