Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA - Custom Menus

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel VBA - Custom Menus

Resolved · High Priority · Version 2003

Reply Fri 15 Oct 2010, 12:25Delegate Ziggy said...

Ziggy has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel VBA - Custom Menus

Hello all

I have a really quick question and cant find the answer anywhere!

I have produced a nice little custom menu to action a set of options (macros).

A number of these options can be selected or deslected. Currently when I select a ControlButton the OnAction code runs, the button is marked as selected/deselected and the menu closes.

I would ideally like the menu to remain open/reopen to its previous location after the selection has been made, is this possible?

I assume it must be as this is how a number of the excel menus work.

It is currently for a ControlButton operated within a ControlPopup, in the future I may wish to add another layer of ControlPopups - just in case this affects methodology (so Popup > Popup > Button).

My thoughts are either it is a property of the button/popups that I must set to true, or a line of code I can add to reopen the various popups, but I can't work out the specifics for either.

Some guidance would be hugely appreciated.

Ziggy

For upcoming training course dates see: Pricing & availability

Reply Wed 27 Oct 2010, 16:54Trainer Jacob said...

RE: Excel VBA - Custom Menus

Hi Ziggy

Thanks for your comprehensive overview of what you are trying to do.

To establish a solution will take us beyond this forum and one of my colleagues reckons a couple of hours research will be required along with access to your working files.

I will email you directly with further detail on this and please accept my apologies for the delay in getting back to you.

Regards

Jacob

Excel articles

· Differences In Excel 2003, 2007 And 2010
· Using Excel For Simple Home Accounting And Budgets
· How To Use The New Excel Web App
· How To Take Your Data Out Of The Shade
· What You Need To Know About LOOKUP Functions In Excel 2007/2010

Please browse our web site to find out more about
excel consultancy and other Microsoft training courses.

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips