Custom shortcut Menu with a Popup Control showing data-driven

Custom shortcut Menu with a Popup Control showing data-driven

Post by Um9zc1 » Thu, 04 Sep 2008 05:00:27


Hi Chris,

The problem is that my sub-items need to be queried from the database at
runtime - I think your method wouldn't allow me to do that, nor can I see how
I can code the response to the sub-item selection. I'm not very familiar with
creating menus through macros, so maybe I'm missing something.

Ross
 
 
 

Custom shortcut Menu with a Popup Control showing data-driven

Post by Um9zc1 » Thu, 04 Sep 2008 23:51:01

I just found this code in the Excel section:

Application.CommandBars.ActionControl.Caption

So, all I had to do was assign the same OnAction function to each item in
the popup and when a user selects an item the above command returns which one
they selected. Pefrect!