Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-31-2014, 04:52 AM
NobodysPerfect NobodysPerfect is offline Get and pass name of clicked ActiveX check box Windows 7 64bit Get and pass name of clicked ActiveX check box Office 2010 32bit
Competent Performer
Get and pass name of clicked ActiveX check box
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default 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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Get and pass name of clicked ActiveX check box How to Pass Document to this Sub ilcaa72 Word VBA 1 01-28-2014 03:04 PM
Get and pass name of clicked ActiveX check box Can pass .expression as a parameter? 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
Get and pass name of clicked ActiveX check box How do I Convert All Legacy Check Boxes to ActiveX? GreenPolyps Word 1 12-20-2011 05:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft