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
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