Hey everyone,

I've been looking around Excel VBA websites and the help file for a while
now, as well as just fiddling with the program, and everywhere I look I find
snippits and hints of the ability to make custom forms or something similar,
complete with comboboxes, radiobuttons and the like, but can't for the life
of me find a tutorial on how to use them properly. Does anyone know of such a
tutorial, or is willing to just help me out? It'd solve so many problems for
me if I could have a simple for pop up prompting the user to enter / choose
information instead of doing it all with endless inputboxes coming up,
followed by annoying messageboxes if they enter something invalid.

Thanx in advance for your help.

This is a crib from a reply Tom Ogilvy has given before, a few articles to
read

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

http://support.microsoft.com/default...;EN-US;Q168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp

Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"The Wonder Thing" wrote in
message ...
Hey everyone,

I've been looking around Excel VBA websites and the help file for a while
now, as well as just fiddling with the program, and everywhere I look I
find
snippits and hints of the ability to make custom forms or something
similar,
complete with comboboxes, radiobuttons and the like, but can't for the
life
of me find a tutorial on how to use them properly. Does anyone know of
such a
tutorial, or is willing to just help me out? It'd solve so many problems
for
me if I could have a simple for pop up prompting the user to enter /
choose
information instead of doing it all with endless inputboxes coming up,
followed by annoying messageboxes if they enter something invalid.

Thanx in advance for your help.