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 Status Bar Using VBA

The status bar in excel can be used as a code monitor. When your VBA code is lengthy and you do several tasks using VBA, you often disable the screen ...

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...

Display a CommandBar centered on the screen using VBA in Microsoft Excel

With the macro below, you can display a CommandBar centered on the screen, both horizontally and vertically. The macro also shows how you can get the...

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...

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