Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create & use User Forms
I am somewhat of a novice with VBA. But I have noticed it is possible to create User Forms. I am thinking these might be much more flexible than the Data Form, since the data form needs all data to be in columns with a header. Is there an MVP site that has a tutorial in creating & using User Forms and using VBA to take advantage of the data? -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=496182 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create & use User Forms
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...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- HTH Bob Phillips (remove nothere from email address if mailing direct) "DCSwearingen" wrote in message news:DCSwearingen.20phhy_1135699200.8447@excelforu m-nospam.com... I am somewhat of a novice with VBA. But I have noticed it is possible to create User Forms. I am thinking these might be much more flexible than the Data Form, since the data form needs all data to be in columns with a header. Is there an MVP site that has a tutorial in creating & using User Forms and using VBA to take advantage of the data? -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=496182 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create & use User Forms
I have bookmarked these articles for future reference!! Thank you for the help!! :) -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=496182 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
Excel user management | Excel Discussion (Misc queries) | |||
New user in need of assistance excel pop-ups, forms, +more!! | New Users to Excel | |||
find and match the max | Excel Worksheet Functions |