Create a UserForm containing a dynamic number of controls and make sure they are being triggered by certain events. To achieve this result, we will use a UserForm and a class module, and assign any ...

This is a simple demo on how to perform basic operations like Create, Read, Update and Delete information stored in an Excel table with a userform, a listbox and some command buttons. To use it just ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

How to use the VBA procedure Once you’ve added the procedure to your Excel workbook file via the VBE, you can execute it against any data range on any sheet in your workbook.

Launch Excel and open a spreadsheet that contains multiple columns. Press "Alt-F11" to open the "Visual Basic" editor and click "Insert | Module." VBA adds a new module to the Project window.