How to create & use User Forms

D

DCSwearingen

I am somewhat of a novice with VBA. But I have noticed it is possibl
to create User Forms. I am thinking these might be much more flexibl
than the Data Form, since the data form needs all data to be in column
with a header.

Is there an MVP site that has a tutorial in creating & using User Form
and using VBA to take advantage of the data?
:confused
 
B

Bob Phillips

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?kbid=168067
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

(remove nothere from email address if mailing direct)

"DCSwearingen" <[email protected]>
wrote in message
news:D[email protected]...
 
D

DCSwearingen

I have bookmarked these articles for future reference!!

Thank you for the help!! :
 
Top