ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamically adding code (https://www.excelbanter.com/excel-programming/314252-dynamically-adding-code.html)

Martin Walke

Dynamically adding code
 
Hi,

Can someone tell me whether it's possible to add code to a control that I've
dynamically added to a spreadsheet?

TIA
Martin



Tom Ogilvy

Dynamically adding code
 
See Chip Pearson's page on programming the VBE:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Martin Walke" wrote in message
...
Hi,

Can someone tell me whether it's possible to add code to a control that

I've
dynamically added to a spreadsheet?

TIA
Martin





Martin Walke

Dynamically adding code
 
Many thanks for the quick reply Tom. Excellent site for reference and those
"how *do* I do that?" questions. Should have realised I would have to play
around with the project object model!

Thanks again
Martin

"Tom Ogilvy" wrote in message
...
See Chip Pearson's page on programming the VBE:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Martin Walke" wrote in message
...
Hi,

Can someone tell me whether it's possible to add code to a control that

I've
dynamically added to a spreadsheet?

TIA
Martin








All times are GMT +1. The time now is 01:27 PM.

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