Max,
I'm just starting to get my hands on userforms.
I was able to download the example you suggested.
One question I have, how do you associate a combo box with a specific set of
cells.

For example, in the sample's sheet "ValidationSample" there are only 10 blue
cells that are linked to the list of weekdays. Each cell seems to have a
combo box associated with it that is the exact same size as the cell itself,
and changes size if you change cell height or width. How does this hapen?
--
Richard


"Max" wrote:

Autocomplete? Recollect Debra Dalgleish once posted:

.. Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for:
DV0043 - Data Validation Combobox With Entry Check
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
I have a long list of names in the validation database, so scrolling through
the entire list takes a long time.

Is there a way to set up the name find so that as a user starts to type in
the first letters of a name it automatically goes to the right name?

For example if they type "M", it goes to first name starting with "M"; and
if they continue "ME" it goes to first name starting with "ME"?

If basic Excel does not have this feature, do you know of any add-ins or
third party additions that cover this feature?
--
Richard