Works like a charm..thanks.

One minor question left.
I use the list funtion with data on another sheet. how can I change the code
to use that data.

last question
The combobox comes up with a double clik, can i change that so that when i
want to fill in the cell by one clik that the combo box is active?

thanks

Peter

"Max" wrote:

What i want is that it will autocomplete what i type.

Debra Dalgleish shows a way to "build in" the AutoComplete feature into DVs,
which finds matching items in the list as you start to type ..
http://www.contextures.com/xlDataVal10.html
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---