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

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

Converting a table of data with multiple columns into a single column in Microsoft Word can be done in several ways. You can use the INDEX or OFFSET macro commands to create a function that generates ...