VBA: Autofill based on list in another sheet

Hi Jan Inge,
how about this:
a named range "Lijst" with range:

Please Login or Register  to view this content.

and in the data validation box on A7 (in the Objektliste) in "Source" the following code "=Lijst"
after this you can copy this down.

After typing the first letters you can click on the validation arrow and it will give a list of those items containing these letters.
(In the background there is an event macro running on each change in column 1 to fill the needed variable Utstyrstype.)

BTW it was -for me- necessary to sort the items alphabetically! It looks nicer in the dropdownlist.

Cheers
Erwin