interactive vba

[Hervé Hanuise]

Hi !

In the project I have, and for didactical purpose, I would
like to automatically populate a "Commands" sheet with
buttons: one button per existing SUB of the vba module.

As my workbook starts empty, I want to automatically :
- add a new sheet and name it "Commands"
- populate the sheet with one button per existing vba SUB
in the module.

Does anyone have ideas for doing this automatically ?

Thanks and very best regards+

 

[Tom Ogilvy]

See Chip Pearson's site for the type of code you need to identify your subs:

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