Data entry,user forms

**MLMcM** · 07-16-2010, 03:18 AM

Is there an easy way to setup a user form in excel 2007 ?
Ideally the column headers would serve as a table or data list,which would then become the fields in the form.
The primary purpose is to have the form used for data entry & also act as a basis for searching the records.
Once the data has been entered into a new form this would have to be saved into the data sheet on the next available vacant row.
Can this be acheived in excel or am I just wishful thinking ? any help would be appreciated.

**royUK** · 07-16-2010, 03:37 AM

Take a look at the DatabaseForm here

http://www.excel-it.com/vba_examples.htm

**MLMcM** · 07-16-2010, 04:23 AM

Many thanks for your help. I think this may work

**royUK** · 07-16-2010, 04:25 AM

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