Can you determine which is the "Active" shape usin

[sbendbuckeye]

Hello All,

I am creating a series of CheckBoxes in worksheet based on user actions using this command:

' strAddress, lngLeft and lngTop are all calculated variables.
With Sheet1.Shapes.AddFormControl(xlCheckBox, lngLeft, lngTop, 10, 10)
    With .DrawingObject
        .Caption = vbNullString
        .LinkedCell = strAddress
    End With
    .Name = "chk" & UCase$(strAddress)
    .OnAction = "CheckBox_Click"
End With

I want to use a generic CheckBox_Click method to handle all of the associated CheckBox events, but I can't find anything to tell me which one has been clicked when the method is called at run time.

There is a parameter property but I am not sure if or how I can use it in this scenario. Am I missing something obvious here? Thanks in advance for any ideas and/or suggestions!

 

[Norie]

I think what you want to look at is Application.Caller.

Private Sub CheckBox_Click()
     Msgbox Application.Caller
End Sub

 

[sbendbuckeye]

Thanks Norie, that is exactly what I was looking for! I don't do Excel on a daily basis so I forget some of these types of things over time. I was pretty sure it was something in the Application object but couldn't find it.