Look at the matchentry property of your combobox. See help for details.

--
Regards,
Tom Ogilvy


"EagleWolf" wrote
in message ...

I have a problem, have search for a soulution but not find any, so why
this Q!

I have a ComboBox filled with items like
101201
210123
334455
335678
420045
446789

What I will have is following.
When I type in the ComboBox I will that the nearest item is
selected/markt (autocomplet) like when I type 33 in the ComboBox
the value 334455 is selected/markt.
The 4455 is filled in automatic
If I add a 5 after the 33 (335) that should generate that the 678 fills
in automatic.

Is this possible to get?
(Excel 2003 + VBA)

EW


--
EagleWolf
------------------------------------------------------------------------
EagleWolf's Profile:
http://www.excelforum.com/member.php...o&userid=28756
View this thread: http://www.excelforum.com/showthread...hreadid=484445