Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Options
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Options
Surely, the double-click can be trapped by the worksheet event, so you know
which one there, and the menu item would have an OnAction macro, so you know which on there. Do you knows how to code those? -- HTH RP (remove nothere from the email address if mailing direct) "Glen Mettler" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Menu Options
Glen
On Error Resume Next MyPik = Application.etc... On Error Goto 0 If Len(MyPik) = 0 Then 'Double clicked Else 'Menu End If -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Glen Mettler" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |