How to get the active command?

matteo_callimaco · General User Joined: 19 Nov 2006 Posts: 23

Hi all!
I have a problem whit getting the name of a command which is in a spreadsheet.
The command is a combobox and this command has a macro asssociated whit its event "textChanged". The macro which is callled by the command needs the name of the command itself and, since there are several comboboxes which refere to the same macro, I can catch the name manually.
When I change the text in the combobox the focus is on it because I've the cursor in it and so I think that there will be something that tells about the active command....
I've tried

B Marcelly · Posted: Sat Dec 30, 2006 2:43 am Post subject:

What you call command is probably the control. A ComboBox is a control. A button is also a control.
I understand you need the name of the control which triggered the event you are handling.
Easy:

matteo_callimaco · General User Joined: 19 Nov 2006 Posts: 23

Thank you!
Only one last question...I have several CONTROLS which have the same macro associated with the same event ("textChanged"). This will create problems in the detection of the trigger control?
The macro associated to controls doesn't know which control has been activated and so I can't use the search by name as you do with if MyControl.name = "xxxx"
And finally, what about evt As Object?
I can't insert argument in my macro...so I need to reply it in the code of the sub. What is that object?

ms777 · Super User Joined: 07 Feb 2004 Posts: 1355

TAG is the keyword to search for ... see http://www.oooforum.org/forum/viewtopic.phtml?t=35571&highlight=tag and B Marcelly's reference therein

matteo_callimaco · General User Joined: 19 Nov 2006 Posts: 23

Thank you ms777! You're always the best!