Adding button to worksheet

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.
 
R

reklamo

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
 

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

Bizarre option button behavior 2
How to use multiple command button to copy user form data to multiple worksheet 0
Linking Cell Data to Text Boxes on a Form 1
macro using forms button 1
cell value from different worksheet 3
Toggling Button Labels Between Expand/Collapse 1
Code to Hide Rows 3
Excel crashes and restarts when accessing newly created worksheet 2

Top