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


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