Hi!
I added several sets of ActiveX option buttons to a worksheet. I want to identify which button in each group has been selected. Each group is uniquely named. Each option button is uniquely named. I am referencing the objects as OLEObjects.
Groups:
AppUse
Logins
Downloads
Buttons:
obYesAppUse, obNoAppUse
obYesLogins, obNoLogins
obYesDownloads, obNoDownloads
I was not getting the result I expected, so I checked to get a count of OLEObjects on my sheet, and the response I received was zero. It appears that my option buttons are not getting recognized as OLEObjects, and that's why I'm not getting my expected results. I am clearly missing something basic, but I don't know what.
I ran this to perform a basic check of my assumption regarding the option buttons being OLEObjects and was surprised to see zero OLEObjects.
Sub CheckButtons()
Dim ctrl As OLEObject
MsgBox "start"
Dim i As Integer
i = ActiveSheet.OLEObjects.Count
MsgBox (i)
End Sub
I would appreciate some help getting pointed in the right direction.
Thanks -
Art