Get and pass name of clicked ActiveX check box
Hi to all,
I‘d like to pass the name (or parts of it) of a clicked check box (ActiveX) to a sub which – according to the passed characters – executes different commands
With Forms check boxes I can use Application.Caller to find out which check box has just been clicked. I’m looking for an ActiveX equivalent.
Example:
- Private Sub cb_1a_Click should do nothing but pass the number of the question (“1”) and the choice (“a”) to the Sub DoWithBox(oNum as String, oChr as String)
- Sub DoWithBox then runs different commands depending on passed oNum and oChr
My problem: I do not know how to retrieve the clicked check box’ name – I mean it is part of the Private sub heading, so it is known, but I simply (?) find no way to pass it. Maybe I just don’t have enough experience with Excel VBA.
Thanks for your help
NP
|