View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AllSensibleNamesTaken AllSensibleNamesTaken is offline
external usenet poster
 
Posts: 10
Default Event Handlers: Getting a handle to the calling object

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