Sample Application Description

This document describes how to create an Excel wizard. VBA is powerful enough to create custom wizards, and it's a fairly simple matter to write one. The histogram wizard discussed here shows how close VBA can come to matching the Chart Wizard that's built in to Excel. The histogram wizard is a demonstration of what is possible with VBA rather than an attempt at the perfect histogram utility. It includes a number of bullet-proofing features such as validation of the selected data and user-specified dialog items—it's a good jumping-off point for other projects.