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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top