Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
option button
In Excel 2007 how do I programatically check to see which option button is
checked? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
option button
There are 2 types of Option buttons that can be used on worksheets. One from
the Forms controls and the other from ActiveX controls. Which ones are you using? The following code would find all the ActiveX option buttons on the activesheet and the MsgBox displays their name and value. If not using ActiveX controls then get back to me and I will see if I can help further. Note that a space and underscore at the end of a line is a line break in an otherwise single line of code. Dim oleObj As OLEObject With ActiveSheet For Each oleObj In .OLEObjects If TypeName(oleObj.Object) _ = "OptionButton" Then MsgBox oleObj.Name & " = " _ & oleObj.Object.Value End If Next oleObj End With -- Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help on how to grey out one option button in one group box based on the selection of another option button in another group box | Excel Programming | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button | Excel Programming | |||
Option button help | Excel Programming | |||
option button | Excel Discussion (Misc queries) |