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.
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.
Dim ctrl As OLEObject
Dim i As Integer
i = ActiveSheet.OLEObjects.Count
I would appreciate some help getting pointed in the right direction.