Dialog-to-UserForm Wizard for Excel 97

Return to The Spreadsheet Page

Excel page

Excel files

Dialog-to-UserForm Wizard screen shot


Overview

The Dialog-to-UserForm utility is for Excel developers -- and can literally save hours of time. It automatically converts an Excel 5/95 custom dialog box to an Excel 97 UserForm. It does not do any conversion of VBA code.

NOTE: Dialog-to-UserForm Wizard requires Excel 97. It will not work with previous versions of Excel.

Excel 97 incorporates an entirely new method of dealing with custom dialog boxes. You create your dialog boxes on UserForms, which you access in the Visual Basic Editor. The Dialog-to-UserForm Wizard converts a dialog box developed with Excel 5 or Excel 95 into a UserForm. It's all done in the blink of an eye, with amazing accuracy and attention to detail.

It's important to understand that Excel 97 still supports Excel 5/95 dialog sheets. Therefore, you may not need to convert your old dialog boxes to UserForms. But for developers who want to upgrade their apps to take advantage of the new capabilities available in Excel 97 UserForms, the Dialog-to-UserForm Wizard will make the task much easier.

Features

  • Uses the familiar "Wizard" interface -- a series of dialog boxes that let you specify exactly how the conversion is performed
  • For each workbook, you choose which dialog boxes to convert
  • You can choose to use the existing names, or generate new names for the controls
  • Produces a detailed Error Report that describes potential problems with the conversion
  • The converted UserForm controls maintain all of the properties of their dialog sheet counterparts.
  • Dialog box objects that are within a GroupBox object, are automatically converted to controls placed with a containing Frame control (which is exactly what you want!)
  • Use it once, and it's paid for itself in terms of time saved.
  • Blazingly fast!
  • Amazingly accurate!

Download

  • Download the Dialog-to-UserForm Wizard (66K)
    Requires Excel 97. The file (dlgwiz.exe) is a self-extracting archive. After downloading, execute dlgwiz.exe to extract dlgwiz.xla and dlgwiz.doc. The dlgwiz.doc file contains installation instructions and complete documentation.

.