When I create User Form, I can click Insert and then User
Form. But I can't find the similar method to create a
diaglog box.

Can someone please tell me how can I create a custom
diaglog box s.t. I can put combo box, list box and check
box as well as buttons in their associate to a bunch of
VBA codes behind each.

It'd be nice someone directs me to some samples.

Thanks in advance for your assistance.

Right-click on the worksheet tab and choose Insert | MS Excel 5.0 Dialog.

--

Vasant

"Wellie" wrote in message
...
When I create User Form, I can click Insert and then User
Form. But I can't find the similar method to create a
diaglog box.

Can someone please tell me how can I create a custom
diaglog box s.t. I can put combo box, list box and check
box as well as buttons in their associate to a bunch of
VBA codes behind each.

It'd be nice someone directs me to some samples.

Thanks in advance for your assistance.

The userform is the dialog box. You put your controls on the userform.
When the userform appears in the VBE, the control toolbox toolbar should
appear as well, and you can pick the controls you want form there. Click
one and then trace a small box on the userform with the mouse where you want
the control to appear.

Here are some sources of information:


20 to 30 pages of instructions:
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

A TUTORIAL:
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.



http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy


"Wellie" wrote in message
...
When I create User Form, I can click Insert and then User
Form. But I can't find the similar method to create a
diaglog box.

Can someone please tell me how can I create a custom
diaglog box s.t. I can put combo box, list box and check
box as well as buttons in their associate to a bunch of
VBA codes behind each.

It'd be nice someone directs me to some samples.

Thanks in advance for your assistance.