Create a Form for data entry in Excel

[jh3016]

At my job, I cannot use Access. Therefore, I have to use Excel. Is there a way that I can:
1. Build a form that the user can input the information in
2. Have the data be collected in a spreadsheet
3. Be able to go back via the form and look at a particular record
4. Have combo boxes, check boxes

In other words, I need to replicate Access with Excel.

Any help would be appreciated. Thanks.

 

[MarkBeck]

See Data Menue. Forms. You cannot custom design it like in a database (maybe in later Versions you can, I use Excel 2000).

Questions 1,2 & 3 are positive. Just paly around a bit and you will see. It is quite simple.

Question 4; you can have all these controls, Just Rightclick on the Menu Bar and tick "Control Toolbox". However i believe that Data Validation does not work with Forms.

Mark

 

[xlbo]

1: Yup
2: Yup
3: Yup
4: Yup

You'll need to use VBA to do this unless you use the basic Data Form that MArk mentioned. I would suggest goting to the VBE and creating a new userform. You can drag n drop controls onto it for selections etc. Then have a submit button that enters the data into the spreadsheet. A word of warning though. If you do not have much vba experience, there is a lot to think about - especially in terms of error trapping and if you are wanting to retrieve data as well, it'll add even more compications

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244