Heh,
It's the second one, forms toolbar.
Thank you so much, Dave.
BG
"Dave Peterson" wrote in message
...
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
|