Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a Form to Enter Information Into a Workbook list

Status
Not open for further replies.

john434

MIS
Mar 17, 2004
50
GB
Hi,

I want to create an excel form to collect data in a workbook list.

I need the work book list to be hidden from users. I just want users to open the workbook, fill in a form, submit it and the data to be recorded in a list.

Can anyone help?

Cheers
 
Not sure I understand but I do something similar (I may be miles off)
I create a list of drop down boxes in data validation (then hide the rows and then protect) then my users pick from this list and it is captured on another workbook
If this sounds like what you are looking for and need more help let me know.

Regards, Phil

"If in doubt, hit it with an end user!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top