XL97: Converting Microsoft Excel 5.0 or 7.0 Dialogs to Excel 97

ID: Q167933

The information in this article applies to:

Microsoft Excel 97 for Windows

SUMMARY

You can download a Microsoft Excel 97 add-in to convert a Microsoft Excel 5.0 or 7.0 dialog sheet to a Microsoft Excel 97 UserForm. The Dialog Converter for Microsoft Excel 97 automatically converts a dialog sheet to a UserForm. However, it does not attach any Microsoft Visual Basic for Applications programming code to the new UserForms.

MORE INFORMATION

Obtaining the Dialog Converter

You can download this add-in file from the following Web address:

   http://www.microsoft.com/ExcelDev/e-free.htm

NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address:

   http://www.microsoft.com/

Finding Information About the Dialog Converter

Although Microsoft makes these macros and add-ins available, contact the vendor if you need assistance or more information. For more information about this product, contact Baarns Consulting Group, Inc. at the following Web address:

   http://www.baarns.com/devonly/

The third-party contact information included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

Using the Dialog Converter

The Dialog Converter simplifies the task of converting a Microsoft Excel 5.0 or 7.0 dialog sheet to a Microsoft Excel 97 UserForm. The conversion process creates the UserForm in the existing workbook and retains the Microsoft Excel 5.0 or 7.0 dialog sheet.

NOTE: To use this add-in file, you must have Microsoft Excel 97.

When you use the add-in to convert a dialog sheet to a UserForm, follow these steps:

1. To ensure that the Dialog Converter add-in is selected in the Add-Ins

   dialog box, click Add-Ins on the Tools menu, click to select the Dialog
   Converter 97 check box, and then click OK.

2. Open the Microsoft Excel 5.0 or 7.0 file that contains the dialog sheet

   that you want to convert.

   The add-in converts one or more of the dialog sheets in a file.

3. To start the add-in in Microsoft Excel 97, click Convert Dialogs on the

   Tools menu.

4. Click the Converter tab to select the dialog sheet to convert.

   Click the Position tab to change the top and left properties of the
   controls on the dialog and frame.

   Click the Options tab to change how the add-in converts the dialog. For
   example, you can click "Backup original project before making
   modifications," "Name new controls based on previous control names," and
   "Use standard control dimensions where possible."

   Click the About tab to find information about the add-in.

5. Click OK to generate a UserForm that is based on the dialog sheet you

   selected in the Converter tab.

6. When the "The conversion was successfully completed" message appears,

   Click OK. Please save the file, close, and then reopen Excel before
   you continue to work.

7. To save the workbook, click Save on the File menu.

8. To quit Microsoft Excel, click Exit on the File menu.

When you open the file again, you can view the UserForm in the Microsoft Visual Basic Editor (press ALT+F11).

The products mentioned here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

If you have any problems when you use this add-in, contact the vendor for more information.

REFERENCES

For more information about using add-ins, click the Index tab in Microsoft Excel Help, type the following text

   add-in programs, overview

then double-click the selected text to go to the "Use add-in programs of Microsoft Excel" topic.

Additional query words: 8.00 dialogs user forms userform wizard addin add- in dialog-to-userform Coverter

Keywords          : kb3rdparty kbprg kbtool xlwiz xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbinfo

Last Reviewed: November 5, 1998