Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting value of Option button
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Button Help | Excel Worksheet Functions | |||
Option Button Help | Excel Discussion (Misc queries) | |||
Option Button | Excel Discussion (Misc queries) | |||
selecting more than one option button | Excel Discussion (Misc queries) | |||
Second option button disappears when I make another column | Excel Worksheet Functions |