Guys,

I've managed to get someone to help me with some code on the attached spreadsheet but I'd really like to apply this code to more than one cell. This will make sense when you open the spreadsheet.

The current code works for question 1 but I would like this code to apply to all questions. Can this be done?

Many thanks
Craig.

Craig,

I have attached your spreadsheet with modificationa.

First, I moved the Responses list to Sheet 3 so that if you want to, you can hide that sheet and the user will not ever see the list.

Next, I defined a Range name of "Responses" for the list of values. This included Rows 2 and 3 of column A.

To use validataion for all of your questions, first, you needed to selecte all rows where you want to apply the validation. Then you simply use the "List" type validation which you had done, but then I used this for the list: =Responses