Question about option buttons

[Rekx]

I have a list of clients that I have two option buttons by. One button has the caption "Yes", the other "No". They are linked to a cell.

I got the two buttons to work fine for the first client. But when I add more sets of buttons to the rest of the clients, they get all mixed up and start affecting each other.

How do I seperate them from each other?

Thanks for the help, Adam

 

[DancingDavidE]

Different "Group Names" for the buttons of each client?

 

[Rekx]

O.K.....got that fixed.

One question though...
Is the a command in VBA that will click or unclick a particular option button?

Thanks y'all

 

[HalfAce]

Hi Rekx,
Assuming you're using option buttons from the Controls Toolbox,

ActiveSheet.OptionButton2.Value = True

will set that button as "clicked"

This help?