Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Similar to "Need to know what is selected"
Similar the reference thread title, I need to know what control caused a macro to run. Because of how my code is structured, it would be best if I could know either one of 2 things: - Does a macro "know" its own name? If so, I can get the name of the control from the name of the macro since it's an Event of that very control. - Does a macro "know" what control/event caused it to run? This would be more direct than parsing a macro name for the control name. If it could just tell me its name! In the "Need to know..." thread the thought of nesting a GotFocus event trap could work but if I could more directly find out from a Property or somehow it would be more convenient. Thanks. -- kbuilta ------------------------------------------------------------------------ kbuilta's Profile: http://www.excelforum.com/member.php...o&userid=32367 View this thread: http://www.excelforum.com/showthread...hreadid=521249 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula similar to "countifs" function in excel 2007 | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Similar Problem as "Multiple Matched Lines" | Excel Discussion (Misc queries) | |||
Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions |