Try Data Validation lists but uncheck error message checkbox in Data
validation Dialog, thus users can enter data beyond those in the list!

Regards,
Stefi


€žkippers€� ezt Ã*rta:

Hi,

I am developing a data capture spreadsheet and have started applying lists
to various cells to aid the users when completing the form. I am conscious
that I will not be able to provide a comprehensive list of possible answers
and so I want the list to act as a guide but if the user wants to add
something else they can.

Does anyone know if this is possible ad if so how I can do this?

cheers,