Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I tell if the user has selected a menu option or a popup?
I have a macro that calculates hrs distributed over time. The user can select a menu to start the calculation or the user can double click on a cell in a column I named "Spread" and get a form that allows them to select the kind of spread - Increasing, Decreasing, Level etc. I need to know if the user has selected the menu or the popup. I tried this in the code: MyPik = Application.CommandBars.ActionControl.Caption This will capture the particular menu option but causes an error if no menu option has been excecuted. If MyPik has a value then I will execute a section of code otherwise I will assume the user form and execute another. Any suggestions? Glen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Menu options | Excel Worksheet Functions | |||
menu tools options | Excel Discussion (Misc queries) | |||
Options Menu | Excel Discussion (Misc queries) | |||
Turn off menu options with vba | Excel Programming | |||
Menu Options | Excel Programming |