Posts by TheArtMan


    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.






    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 -