|
Peltier Tech
Chart Add-Ins
Excel Dashboards
Books at Amazon.com
 
 
|
|
Excel and VBA Menus and Command Bars
Here are a few tricks I use for making menus and command bars for my Excel projects.
|
This simple workbook contains the code to build a floating command bar when the file is opened, and delete it when it is closed. The command bar has two popup menus, each of which have two command buttons. No documentation supplied, just the file. Download either the complete Excel file, or the text file that contains just the VBA code you need. |
|
Here is some code that generates a custom drawing command bar with my favorite built-in buttons. I originally wrote it for PowerPoint, but being part of the Office object model, it translated to Excel with only very minor adjustments. Both versions are shown.
Top of Page
|
|
Display all 3000+ of Microsoft Office's built in button faces (screen by screen), so you can choose the right one for your special menu. Mouse over a button, and the ToolTip shows you its ID number. Click on one, and its image and number are stored in a worksheet for future reference. |
|
|
