ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   CommandButton self reference (https://www.excelbanter.com/excel-worksheet-functions/181549-commandbutton-self-reference.html)

makulski

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


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com