Microsoft KB Archive/167933

= XL97: Dialog Converter Add-in Converts MS Excel 5.0 or 7.0 Dialogs to Excel 97 UserForms =

Article ID: 167933

Article Last Modified on 6/12/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q167933



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.



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

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.
 * 1) To start the add-in in Microsoft Excel 97, click Convert Dialogs on the Tools menu.
 * 2) 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.
 * 1) Click OK to generate a UserForm that is based on the dialog sheet you selected in the Converter tab.
 * 2) 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.
 * 3) To save the workbook, click Save on the File menu.
 * 4) 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.

