ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 95 Dialog - Excel 2000 Userform (https://www.excelbanter.com/excel-programming/286158-excel-95-dialog-excel-2000-userform.html)

Ralf Pfeifer

Excel 95 Dialog - Excel 2000 Userform
 
Dear all,

surely there are some of you, who remember, that in Excel 95 the
forms were stored in their own sheet type, together with worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete dialogs
to Excel 2000 user forms. Regarding this, I would appreciate your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs automatically in
XL-2000 user forms? I know, I have to change the code too, but
each dialog includes a lot of pre-settings and they are in proper
shape.
I have already tried the clipboard and dragging with the mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?) are
supported by Office 2000. What's about Office XP, Office 2003?
Is there a roadmap by Microsoft for the end of support of the
old dialogs?

Thanks in advance, Ralf.


Chip Pearson

Excel 95 Dialog - Excel 2000 Userform
 
Ralf,

Go to www.appspro.com , then the Free Utilities section, and
download the Dialog Converter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ralf Pfeifer" wrote in message
...
Dear all,

surely there are some of you, who remember, that in Excel 95

the
forms were stored in their own sheet type, together with

worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete

dialogs
to Excel 2000 user forms. Regarding this, I would appreciate

your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs

automatically in
XL-2000 user forms? I know, I have to change the code too,

but
each dialog includes a lot of pre-settings and they are in

proper
shape.
I have already tried the clipboard and dragging with the

mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?)

are
supported by Office 2000. What's about Office XP, Office

2003?
Is there a roadmap by Microsoft for the end of support of

the
old dialogs?

Thanks in advance, Ralf.




Gord Dibben

Excel 95 Dialog - Excel 2000 Userform
 
Ralf

You can try Rob Bovey's Dialog Converter Add-in.

http://www.appspro.com/

Find under "Free Utilities"

Gord Dibben Excel MVP

On Wed, 24 Dec 2003 00:45:36 +0100, Ralf Pfeifer
wrote:

Dear all,

surely there are some of you, who remember, that in Excel 95 the
forms were stored in their own sheet type, together with worksheets,
charts and modules.

Now I have to convert such a file with 12 really complete dialogs
to Excel 2000 user forms. Regarding this, I would appreciate your
help with two questions:

1. Is there a way, to convert the old XL95 dialogs automatically in
XL-2000 user forms? I know, I have to change the code too, but
each dialog includes a lot of pre-settings and they are in proper
shape.
I have already tried the clipboard and dragging with the mouse.

2. The dialog sheets from XL 95 (is it the forms library 2.0?) are
supported by Office 2000. What's about Office XP, Office 2003?
Is there a roadmap by Microsoft for the end of support of the
old dialogs?

Thanks in advance, Ralf.



Ralf Pfeifer

Excel 95 Dialog - Excel 2000 Userform - Thank you!
 
Ralf Pfeifer wrote:


Thank you all, the Dialog Converter from www.appspro.com
works perfect.

Thanks again, Ralf.



All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com