![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ilcaa72 | Word VBA | 1 | 01-28-2014 03:04 PM |
![]() |
tinfanide | PowerPoint | 4 | 12-28-2012 06:14 PM |
How to pass parameters to a .msg file? | HereNow | Outlook | 0 | 11-05-2012 10:38 AM |
Office 2010 Excel Full pass | raineraus | Excel | 1 | 09-19-2012 12:55 PM |
![]() |
GreenPolyps | Word | 1 | 12-20-2011 05:11 PM |