Adding button to worksheet

  • Thread starter Thread starter Bremser
  • Start date Start date
B

Bremser

I'm trying to simply add a selection button next to each of 3 options on a
proposal form. Each button should toggle between 'selected' and 'not
selected' status. I want to user to be able to click on the button next to
their preferred option to indicate their choice.

Thanks in advance for your help.
 
Hi Bremser

Use the Toolbar "Forms". First insert a Groupbox, as large as needed to
insert 3 option buttons. Then add 3 option buttons in the area of the
groupbox.
When you run a macro use following for each option button:
If ActiveSheet.OptionButtons("OptionButton 1").Value = xlOn Then

regards
reklamo
 
You must log in or register to reply here.

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

Similar Threads

Change color of all option buttons in several worksheets 3
button names changed on copied sheet 4
Userform to Select what worksheets to print 1
Linking Cell Data to Text Boxes on a Form 1
Bizarre option button behavior 2
command button caption 2
togglebutton to act like optionbutton 3
Userform causing a slip for Worksheet activate? 4

Back
Top