Adding button to worksheet
 

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.

Adding button to worksheet
 

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


"Bremser" wrote:

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.