HELP: Inserting a drop down box into a Data Entry Form

I have looked into a similar post which was closed by an admin for being posted in the wrong place "very helpful" and tried almost everything but cannot work this one out.

I Want to reduce the likely hood of error when somebody enters data into a spreadsheet, i have created a Form in which they can easily type the data and then this inputs into excel, but i want to go a step further and within this form enable them to select drop down boxes instead of having to type the data directly, now i don't just want a simple list in a normal excel sheet, when they are entering the data in the FORM option within excel this is where i want the drop down box to appear, i have looked at previous posts and bits on the forum but cannot work this one out.

I have attached some photos to show you what i am trying to do, please help.

Below is the data entry form:

Capture.jpg

And Below is the list style i would like inside this data entry form:

Capture1.jpg

I hope someone can help.

Thanks,

Mike

Firstly,

Thank you for your response. I have attached an edited version with data removed of what i am working with.

The idea is a user clicks the New Entry icon/button (i think this is only visible on my toolbar at the moment), which opens the data entry form, a basic macro i believe.
They then use this to easily input the data as seen in the columns on the sheet attached and previous photos.
On the main sheet of the spreadsheet there are some drop down lists which i have highlighted in red (the data for these lists it pulls from the second tab, not sure if this is correct way to do this), the idea is to allow the user to only select one of those pieces of data in the list to avoid typos and to enable correct filtering. The idea is also to stop them changing and or editing the main list and that they can only input the required information and or select the information from a drop down list. I would like to be able to have a drop down list option within the Data Entry form so the user simply enters for example:

Status: New
Stand Number: 1-00
Hall: Hall 1
Company Name: Test company name
Known as: Test known as name
Sector: (they select a sector from the drop down list only)
Stand Type: (they select a stand type from the drop down list only)

They click (submit) and the data gets entered: In theory.....

etc etc, i hope this makes sense.

I might be going about this all the wrong way, in a nutshell what i need is a way for a very basic user to input set data into an excel sheet with a combination of NEW data they will have and also predetermined options of data, i don't want them to be able to modify existing date or change or mess up the main structure of the work book.

Your help is much appreciated.

Thank you, i thought this might be the case, i did a lot of googling and asked lots of questions before i made it here. I used Visual Basic when i was at college a long time ago now, any advice on best where to start to do this would much appreciated.

Thanks again.

M

Thank you very much, I'm sure I will pick it up, so essentially design the front end first and collate the back end data I need to use for the lists etc and then go from there. I will have a crack today when I get into the office. Once again thanks for your help.

M

Hi jaslake,

This seems to input the data i require fine but i am having difficulty with the following:

1. Entering one lot of data and clicking submit, then enter another lots of data and get it to enter on the next row down (at the moment NEW data overwrites the old)
2. When the form loads again after entering one bit of data i would like it do be blank
3. i would also like to know how to add a "next" button to the data entry form so users can enter multiple bits of data one after the other

I hope you can assist or point me in the right direction, i have spent a lot of time on this now.

Mike