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

After creating UserForm1 for one Excel application, you realize that you’ll want to use it again — with a few modifications — in another application. You do not need to recreate the form; simply ...

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