Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Forms
How do you create a data form from a worksheet and does the information
entered into a data form appear in the worksheet? Once information has been entered into a data form will the form clear so that you can add, say for instance, another client? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Forms
After inserting the last field in your data form, when you press <Tab, focus
moves to the New button. Press this and the new record gets added to the list, while the input fields are cleared. -- HTH Kassie Replace xxx with hotmail "MarkOffice2007" wrote: How do you create a data form from a worksheet and does the information entered into a data form appear in the worksheet? Once information has been entered into a data form will the form clear so that you can add, say for instance, another client? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Forms
hi
if you want to use the built in form like Kassie suggested, you may have to add it to the quick access toolbar. office button excel options customize. if you want to create a custom form then you will have to do some codeing to make the data move to the sheet and more codeing to clear the form. see this site for step by step instructions. code examples are included. http://www.contextures.com/xlUserForm01.html regards FSt1 "MarkOffice2007" wrote: How do you create a data form from a worksheet and does the information entered into a data form appear in the worksheet? Once information has been entered into a data form will the form clear so that you can add, say for instance, another client? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data collection - aggrating forms data ?? | Excel Discussion (Misc queries) | |||
Forms and data | New Users to Excel | |||
Excel Data Entry Forms (Data, Worksheet) | Excel Discussion (Misc queries) | |||
Using data forms | Excel Discussion (Misc queries) | |||
Data Forms | Excel Discussion (Misc queries) |