I am in the process of constructing an Excel-based product that hopefuly will one day hit the eCommerce market. Among other things, this product will allow its user to define their own popup menu.
Continue Reading: A User-Defined Popup Menu »
Create A Dynamic Workbook Collection
I have been developing an addin product that provides a dynamic user popup menu on a specific report worksheet. The popup menu is made available once a report has been created to allow for simple cell and range updating based on menu choices. The file can of course be saved for future use as one might expect.
So as things were moving along, with the addin in place I opened up a saved file with the report in question and found that report worksheet provided the standard cell context popup-menu rather than the popup-menu I was looking for!
Continue Reading: Create A Dynamic Workbook Collection »
PopUp Menus on a Userform
Most of the Office VBA solutions I produce include userforms and the usual controls are there – textboxes, commandbuttons, checkboxes and dropdowns – to present an easy-to-use, functional user interface.
Continue Reading: PopUp Menus on a Userform »
Custom Popup Worksheet Menus
Microsoft Excel has lots of popup (or dropdown) menus (or commandbars) that are made available to the user with a right-click depending on what your doing – hence the term context menu.
Right-click on a cell and you get the "cell" menu. This is subject to customization, allowing you to add items to the menu or disable menu items if desired.
Continue Reading: Custom Popup Worksheet Menus »
Follow Us