ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shortcut Menu With Toggle Control (https://www.excelbanter.com/excel-programming/322825-shortcut-menu-toggle-control.html)

quartz[_2_]

Shortcut Menu With Toggle Control
 
I would like to code a shortcut menu with a control that the user can click
that will cause the item clicked to be checked, if the user clicks the item
again, it will be unchecked - AND - the menu will remain displayed until the
user clicks some other button on the menu. Also, the code would need to
determine whether or not the control was checked.

For example, the user could click "Build New" which would cause this item to
be checked and the menu would remain visible. The user might then click
"Create Detail Report" and then the code would capture whether or not "Build
New" was checked and then run the program "CreateDetailReport".

This shortcut menu would be launched using a right click from the sheet.

I hope this is clear enough. Thanks in advance for your assistance.


All times are GMT +1. The time now is 05:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com