User Forms

Dexter · May 17th, 2002, 10:43 AM

Can someone explain the difference between Userforms and dialogue sheets?

Thanks

kkknie · May 17th, 2002, 12:30 PM

Dialog sheets are from pre XL97 and userforms are from XL97 on...

I have created numerous dialog sheets in the past, and had a bear of a time figuring out what had changed. That is until I started programming in Visual Basic 5.0.

Here's my untechnical and possibly a bit incorrect take on the two:

Dialog sheets were stored as visible parts of the workbook. As far as I know there were not really any objects, methods or events associated with them. This meant that you had to program everything (usually using a lot of extra code and controls).

Userforms are very close to true VB forms (with some of the functionallity missing). You have events, properties and methods associated with them. You can add activeX controls to them. You use the VBA editor (with all of the associated user-friendliness to edit them). They are not a separate tab on the workbook, so you don't have to worry about hiding and unhiding them to keep meddling fingers out. Basically, they are dialog sheets but a whole lot better.

I'm sure that's not all you wanted to know. If you have more specific questions, I'll be glad to do my best to answer. In fact, others may enjoy telling me where I made any mistakes or omissions

K

[ This Message was edited by: kkknie on 2002-05-17 11:31 ]

Dexter · May 17th, 2002, 01:47 PM

K,

Thanks for the reply. Your explanation gives me a great start. Once I research and experiment with them, I no doubt will have more questions. Thanks again.

Dexter

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 10:43 AM	#1
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	Can someone explain the difference between Userforms and dialogue sheets? Thanks

May 17th, 2002, 12:30 PM	#2
kkknie Board Regular Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Dialog sheets are from pre XL97 and userforms are from XL97 on... I have created numerous dialog sheets in the past, and had a bear of a time figuring out what had changed. That is until I started programming in Visual Basic 5.0. Here's my untechnical and possibly a bit incorrect take on the two: Dialog sheets were stored as visible parts of the workbook. As far as I know there were not really any objects, methods or events associated with them. This meant that you had to program everything (usually using a lot of extra code and controls). Userforms are very close to true VB forms (with some of the functionallity missing). You have events, properties and methods associated with them. You can add activeX controls to them. You use the VBA editor (with all of the associated user-friendliness to edit them). They are not a separate tab on the workbook, so you don't have to worry about hiding and unhiding them to keep meddling fingers out. Basically, they are dialog sheets but a whole lot better. I'm sure that's not all you wanted to know. If you have more specific questions, I'll be glad to do my best to answer. In fact, others may enjoy telling me where I made any mistakes or omissions K [ This Message was edited by: kkknie on 2002-05-17 11:31 ]

May 17th, 2002, 01:47 PM	#3
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	K, Thanks for the reply. Your explanation gives me a great start. Once I research and experiment with them, I no doubt will have more questions. Thanks again. Dexter