Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Form
Excel recommends using visual basic ediotr to create a form for data entry;
can someone suggest a few basic steps to create such form? For illustration purpose, lets assume I'm creating a form with the following: Product ID (predefined list) Supplier (predefined list) Quantity Unit Price Total Cost (Q x P$) I also need the entered data to be added to a master sheet that list all records. Thank you!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Form
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 "Natalie" wrote in message ... Excel recommends using visual basic ediotr to create a form for data entry; can someone suggest a few basic steps to create such form? For illustration purpose, lets assume I'm creating a form with the following: Product ID (predefined list) Supplier (predefined list) Quantity Unit Price Total Cost (Q x P$) I also need the entered data to be added to a master sheet that list all records. Thank you!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
form on one worksheet and the list on different worksheet | Excel Worksheet Functions | |||
Worksheet in form | Excel Programming | |||
Worksheet on form? | Excel Programming | |||
Input Form on Worksheet 1, Data on Worksheet 2 | Excel Programming |