Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This worked ok if the optionbutton (from the forms toolbar) was in a groupbox:
Option Explicit Sub testme() Dim optBTN As OptionButton Set optBTN = ActiveSheet.OptionButtons("Option Button 1") MsgBox optBTN.GroupBox.Name End Sub And you can find lots of properties for these old style things in the Object browser (F2 in the VBE.) Right click in the object brower and select show hidden members. Edwin Merced wrote: How can I access the group name property for the option button control provided on the forms toolbar? As well as the other porperties of the form control toolbox? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost Form Controls | Excel Discussion (Misc queries) | |||
Form controls in Excel 07 | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Is it possible to group parts with controls? | Excel Discussion (Misc queries) | |||
User Form Controls | Excel Programming |