All Microsoft Excel Versions

Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel

If you want to get any information from the user you can use the INPUTBOX-function. This function displays a dialogbox that lets the user fill inn an...

Change the value/content of several UserForm-controls using VBA in Microsoft Excel

In an Excel 5/95 dialogsheet it is possible to change the value/content of a collection of controls by looping through the controls in the collecti...

Display a message on the Excel VBA status bar

Certain vba macros / codes take a long time to run or execute the actions required. If you have turned off screen updating using the line Application....

Pass arguments to macros from buttons and menus using VBA in Microsoft Excel

The example below shows how you can create CommandBar buttons/menus that passes one or more arguments to a macro. the example also shows how you can ...

Edit the tooltip for toolbarbuttons using VBA in Microsoft Excel

The examples below uses the New-button on the Standard toolbar as an example. You can replace "Standard" with the name or number of another CommandBa...

Determine which CommandBar button that started a macro using VBA in Microsoft Excel

Let the macros themselves determine which CommandBar button that started them. If you attach the macro below to multiple CommandBar buttons, the mess...

Change the state of a custom CommandBar button using VBA in Microsoft Excel

The macro below shows how you can change the state of a custom CommandBar button so it displays as depressed or not. Sub ToggleButtonState() Dim m A...

Change the availability for the shortcut menus using VBA in Microsoft Excel

The macro below shows how you can toggle the availability state for the shortcut menus. Sub ToggleCommandBars() Dim cbEnabled As Boolean cbEnab...

Change the availability for the CommandBars using VBA in Microsoft Excel

With the macro below you can toggle the availability of the Workbook Menu Bar,the Standard toolbar and a custom CommandBar. The first time you run th...

Change the availability for a menu item using VBA in Microsoft Excel

The macro below shows how you can toggle the availability state for a menu item. Sub ToggleMenuControls() Dim m As CommandBarControl, mi As CommandB...

Page 50 of 105« First...102030...4849505152...607080...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube