Excel - option buttons how to use

[itsgoodtobeking]

How do you use the option buttons? I am trying to put a group of option buttons in line with the cells. I want the user to click whichever line is wanted then have a value appear in another cell.

Can anyone tell me how to do this?

 

[SkipVought]

Hi,

Option Buttons have a Group property. The Option Buttons in an associated group are mutually exclusive -- only one option Button in the group can be TRUE.

You must inspect the value of an Option Button and from the value, you can make a decision.

Skip,

_{[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it!}