View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
makulski makulski is offline
external usenet poster
 
Posts: 26
Default CommandButton self reference

How do I reference the properties of a command button in the code of the
click event?

I assumed it would be "me." but the "me" is not valid.

example, I want to know where the button is located.
I can say CommandButton1.address
but if I want the code to be generic, I don't want to use the actual name in
the code.
I'd really like to say Me.address

How do I do this?
Thanks