Dynamically adding code

[Martin Walke]

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]

See Chip Pearson's page on programming the VBE:

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

 

[Martin Walke]

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