The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

While something like a drop-down list might seem too cumbersome for your daily use, it's important to remember that Excel's ability to customize and automate tasks dramatically enhances productivity.

How to Create a Check Box in Excel 2007. Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form ...

In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.