Hi,

I've searched a few forums, but despite many similar sounding threads I can't find a solution to the following:

I have a number of lists on worksheet 1 and a user form on worksheet 2. Worksheet 1 is hidden, so users open the spreadsheet then populate cells with a data validation drop-down list from worksheet1. Easy...... but not satisfactory! Some of the lists are quite long and the users now want to be able to start typing the list text so they can then select the correct text from the drop-down in a 'searched' or even auto-populated way.

Is this possible (I'm running Excel 2003)?

(I tried hiding rows of data above the input array so it would autopopulate, but due to variations on the same names it doesn't offer a suggestion until the majority of the text is typed - also doesn't work if something has been mistyped.)

I hope this makes sense - all help is gratefully appreciated.

Cheers,

Wes