If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|