Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Building something in Excel using VBA. Is there a way to access the element that fired the event within the event handler? for example: Sub ComboBox1_Click() 'Currently I am doing the following ComboBox1.doSomething(bla,bla) 'Am I doomed to have to get at this object by name, and hence have to change 'the event handler code of all the different combo boxes in the 'sheet in order to match their name? 'Ideally there would be a "this" keyword to use, but I don't think VBA has that. 'Any other way End Sub Thanks so much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Need help with adding Controls and event handlers at runtime | Excel Programming | |||
Further Clarification with Event Handlers & Class Modules | Excel Programming | |||
Grouping Event handlers | Excel Programming | |||
Problems with event handlers | Excel Programming |