Option Buttons Group

[Lance-R]

Howdy,

I've searched the non-existent documentation in Excel, tried the internet and what books I had but cannot find the answer.

In Access, I can create an option group, and then that group will have an attached value based on which button is chosen, which I can then use in a case statement or in other creative ways.

In Excel, I've created an option group with a groupname, but I can't find anyway to access this value. If it doesn't exist then how do you make the decisions in code without checking every option button?

 

[RoryA]

You do check the option buttons - I usually use a Select Case True statement.

 

[Norie]

How exactly have you created these option buttons?

 

[Lance-R]

whoops, sorry.

I used the Active-X controls, just dropped two buttons, then changed the groupname in properties.

 

[RoryA]

Are they on a userform or a worksheet?

 

[Lance-R]

Worksheet.

 

[RoryA]

You either have to loop through them in code, or set each one's LinkedCell property to a different cell and check which contains TRUE.

 

[Lance-R]

Thanks, I sure wish the Excel people would talk to the Access people.
Good things could happen.