Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CustomMenu.Controls.Add
I have been using the CustomMenu for a while, but what I want to do is have
one menu option have multiple menu options "built" off it. For example, when I trace down the File Menu to Print Area, I have an arrow for additional choices, Set Print area and clear print area. I want to build these types of additional choices. What is the syntax for this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CustomMenu.Controls.Add
Add a pop-up control (which is what a menu is), and to this add your command
buttons. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike H." wrote in message ... I have been using the CustomMenu for a while, but what I want to do is have one menu option have multiple menu options "built" off it. For example, when I trace down the File Menu to Print Area, I have an arrow for additional choices, Set Print area and clear print area. I want to build these types of additional choices. What is the syntax for this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CustomMenu.Controls.Add
The first example on this page shows the code to do this:
http://peltiertech.com/Excel/menus.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jon Peltier" wrote in message ... Add a pop-up control (which is what a menu is), and to this add your command buttons. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mike H." wrote in message ... I have been using the CustomMenu for a while, but what I want to do is have one menu option have multiple menu options "built" off it. For example, when I trace down the File Menu to Print Area, I have an arrow for additional choices, Set Print area and clear print area. I want to build these types of additional choices. What is the syntax for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
For Each Ctl In Me.Controls | Excel Programming | |||
add controls | Excel Programming | |||
Excel controls vs vba controls | Excel Programming | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Event procedures for controls added with Controls.Add | Excel Programming |