Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create pop menu in macro ?
Hi VB Guru! Is it possible to create a pop up menu in macro?, Let say I
have 8 macros in 1 spreadsheet, I use these macro quite often, how can I put all these macros in one pop up box and I can select it whenever I want, rather than keep pressing Alt-8 or make the short cut. Please help. It would be great if the pop menu is always on top. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create pop menu in macro ?
You could build yourself a custom userform with a bunch of command buttons
on it and display it modelessly if you are in XL2000 or above, but... Why not just build a toolbar. That's what they are for. John Walkenbach has some code to build one on the fly on his site www.j-walk.com. Or, if this is just for your use, just build a custom toolbar and attach it to your sheet. Robin Hammond www.enhanceddatasystems.com "broogle" wrote in message ups.com... Hi VB Guru! Is it possible to create a pop up menu in macro?, Let say I have 8 macros in 1 spreadsheet, I use these macro quite often, how can I put all these macros in one pop up box and I can select it whenever I want, rather than keep pressing Alt-8 or make the short cut. Please help. It would be great if the pop menu is always on top. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
create dropdown menu | Excel Worksheet Functions | |||
Create a New Menu | Excel Programming | |||
Create a New Menu | Excel Programming | |||
Create a new menu in VB | Excel Programming |