User Input

T

The Wonder Thing

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.
 
B

Bob Phillips

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.aspx?scid=KB;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-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp

Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

--

HTH

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