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