CustomMenu.Controls.Add

's Computer Specifications

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?

's Computer Specifications

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." <(E-Mail Removed)> wrote in message
news:3627BF03-F9AD-4D8D-A6FD-(E-Mail Removed)...
>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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:%23SlMw%(E-Mail Removed)...
> 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." <(E-Mail Removed)> wrote in message
> news:3627BF03-F9AD-4D8D-A6FD-(E-Mail Removed)...
>>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?
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making a controls ID property inside a repeater controls ItemTemplate the value of the ItemIndex?	Andy B	Microsoft ASP .NET	1	15th Nov 2008 07:17 PM
Controls.Count, Controls.IsSynchronized, and Controls.SyncRoot	Nathan Sokalski	Microsoft ASP .NET	4	5th Sep 2007 04:27 AM
Why the properties of web user controls which inherted from my custom base UI controls missed?	ABC	Microsoft ASP .NET	0	21st Nov 2005 04:08 AM
Message box breaks owner draw controls in .NET controls used as ActiveX controls (again)	Clive Dixon	Microsoft Dot NET Framework Forms	0	26th May 2004 10:15 AM
How to force the child controls OnClick event before the parent controls CreateChildControls method?	Arulraja	Microsoft ASP .NET	3	17th Oct 2003 05:22 PM