Hi,
I am trying to see if is possible to enter data on a form and save the data to a second page in the same workbook. I need this to create a new entry each time the form is filled in.
Grateful if ayone could please point me in the right direction.
Artizan
There is a Form available from the Data menu. It is still available in Excel 2007 but you have to add it to the Quick Access Toolbar.
Otherwise you can create a form in VBA
Last edited by royUK; 12-13-2010 at 07:49 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
RESOLVED - Thank you
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks