LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Menu options Luis Elguezabal Excel Worksheet Functions 1 May 8th 08 02:59 PM
menu tools options jim w Excel Discussion (Misc queries) 0 October 11th 07 04:51 PM
Options Menu abarger123 Excel Discussion (Misc queries) 5 August 17th 05 04:38 PM
Turn off menu options with vba nath Excel Programming 1 August 10th 04 05:44 PM
Menu Options Kevin Hill Excel Programming 3 February 17th 04 04:26 AM


All times are GMT +1. The time now is 03:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"