Software

Ask something
Discussion Locked

Creating a form with Database in Excel

0 helpful
3 replies

by topic

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create a form that adds the data entered into a hidded database. I know that Access would be the better choice than Excel, but Access is not an option.

Every time a form is completed I need part of the data to be added to a database. the form must also include a dropdown list where the user can make predefined choices. Also tick boxes etc. how can I lnk these to a databse that will be hidden away from the user.

3 replies

by leobloom

The best way would be to create the form that you want to use, then click on the data menu and go to template wizard. This will make a template out of the form and create a database on a separate spread sheet. If you are using Excel 97 then the template wizard was probalby loaded with the program on default. If you are using Excel 2000 or later you might have to load the template wizard.

by topic

Thank for the info. I ahve not yet tried the efficiency of your reply, but it sounds cool, as I have never tried to use the Template tool.

Thank you for the tip!

This discussion is closed to new replies.