View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default group name for form controls

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