PDA

View Full Version : Solved: Dialog Sheets



jammer6_9
02-06-2008, 05:48 AM
How can I set Dialog Sheet(Frame) to show in Center Screen Only and restrict user not move it...

Jan Karel Pieterse
02-06-2008, 11:35 AM
Why would you use such an ancient technology (dialog sheets go back to Excel 5/95)?

jammer6_9
02-08-2008, 11:45 PM
:rotlaugh: A project was pass on to me where it has 27 dialog sheets. Me eitther is not used to it. So then I have to change all dialog sheets to userform :banghead: ... Well then thanks for the advice...


Why would you use such an ancient technology (dialog sheets go back to Excel 5/95)?

Paul_Hossler
02-09-2008, 12:38 PM
Haven't tried this free add-in, but Baarns has some other add-ins that I've used and like

http://archive.baarns.com/download/Dlg_Conv.exe

One of the most important changes to Excel 97 VBA is the addition of a true Forms package. In order to take advantage of this powerful new feature you must convert all of your Excel 5/95 Dialog sheets into Excel 97 UserForms. The Excel 97 Dialog Converter takes most of the hassle out of this process by automatically converting the structure of your Excel 5/95 Dialog sheets and their controls into new Excel 97 UserForms with corresponding ActiveX controls.

Paul

jammer6_9
02-09-2008, 11:35 PM
Perfect... Thanks Paul :friends:


Haven't tried this free add-in, but Baarns has some other add-ins that I've used and like

http://archive.baarns.com/download/Dlg_Conv.exe

One of the most important changes to Excel 97 VBA is the addition of a true Forms package. In order to take advantage of this powerful new feature you must convert all of your Excel 5/95 Dialog sheets into Excel 97 UserForms. The Excel 97 Dialog Converter takes most of the hassle out of this process by automatically converting the structure of your Excel 5/95 Dialog sheets and their controls into new Excel 97 UserForms with corresponding ActiveX controls.

Paul