MAKING EXCEL WORK FOR YOU

Heading

 © Roy Cox 2005 to 2013

Our Privacy & Cookie Policy


An Excel DatabaseForm to adapt for your own projects

MS Access is the obvious database application for Microsoft Office users, but


Two major tasks related to using an Excel database are entering the data correctly and then keeping that data up to date. Excel has a built in data entry form that can help simplify both tasks.

My DatabaseForm demonstrates how to build your own UserForm to carry out these tasks.

Click to view full sized image

This UserForm addresses many of the commonly asked questions by people building their own form

Data entry can be further enhanced by restricting entries to a list, much like a Data Validation list on a Worksheet. This can be done by using a ComboBox.

If you would like this form adapting for your use, or maybe a more advanced form then please contact royUK using the contact form.for a quote.

The download now contains a more advanced dataform example that is used as a Contacts Manager.

Read more about the new form.