The MinimiseMaximiseIcons.bas module ensures that your UserForms are equipped with Maximize and Minimize buttons, regardless of whether you're running a 32-bit or 64-bit version of Excel. By ...

After typing your code, click the Run button and select Run Sub/UserForm. Minimize the Microsoft Visual Basic for Application window to see the results. If you want to delete the module, maximize ...

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

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

How to Make a Button in VBScript Using Excel. Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter ...

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.