ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Drop down list of Macros (https://www.excelbanter.com/excel-programming/381234-drop-down-list-macros.html)

Harry's GMail World

Drop down list of Macros
 
I have 12 macros that I would like to access from a drop-down list
rather than go to Alt-F-8.


NickHK

Drop down list of Macros
 
If you do not want to hard code the macro names in a routine/range that
populates the combo box, then you need access to the WB's code and build the
list dynamically:
http://www.cpearson.com/excel/vbe.htm

NickHK

"Harry's GMail World" wrote in message
oups.com...
I have 12 macros that I would like to access from a drop-down list
rather than go to Alt-F-8.





All times are GMT +1. The time now is 09:35 AM.

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