What kind of optionbutton--from the control toolbox toolbar or from the Forms
toolbar?


'control toolbox toolbar
MsgBox Worksheets("sheet1").OptionButton1.Value

'forms toolbar
MsgBox Worksheets("sheet1").OptionButtons("Option button 1").Value

BG wrote:

Hi

I put some option buttons (radio buttons) on an Excel worksheet and found it
hard to get the values of these buttons.
When using f.ex.

For Each S In ActiveSheet.Shapes
msgbox s.Name
Next S

I can see that all the buttons are on the sheet but I can't read tha value,
which is the mai goal to use option button.

Any help would be greatly appreciated.

Blind gate

--

Dave Peterson