ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Buttons (https://www.excelbanter.com/excel-programming/340344-buttons.html)

alecbowman

Buttons
 

I have some VB to generate charts based on engineering data.

To make these easier to manipulate, I want to add a button to any char
that is produced. These buttons would need to have a procedure assigne
as appropriate.

Initial thoughts are that this wouldn't be easy to do as the button i
seems to increment each time one is created.

Any ideas gratefully received.

Ale

--
alecbowma
-----------------------------------------------------------------------
alecbowman's Profile: http://www.excelforum.com/member.php...fo&userid=2267
View this thread: http://www.excelforum.com/showthread.php?threadid=46838


Tom Ogilvy

Buttons
 
You can then rename the button. (with code of course)

--
Regards,
Tom Ogilvy

"alecbowman" wrote
in message ...

I have some VB to generate charts based on engineering data.

To make these easier to manipulate, I want to add a button to any chart
that is produced. These buttons would need to have a procedure assigned
as appropriate.

Initial thoughts are that this wouldn't be easy to do as the button id
seems to increment each time one is created.

Any ideas gratefully received.

Alec


--
alecbowman
------------------------------------------------------------------------
alecbowman's Profile:

http://www.excelforum.com/member.php...o&userid=22679
View this thread: http://www.excelforum.com/showthread...hreadid=468386





All times are GMT +1. The time now is 12:24 AM.

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