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

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

OK.
I made a test and get it to work when I used AddItem ore ListFillRange
But when I assigne data to the ComboBox like

vaData = .Range(.Range("A2"), .Range("A65536").End(xlUp)).Value
..List = vaData

It not work with autofill!

Is it wrong way to do it?

I made some outher soulution of this.
(Data on one sheet and Combobox on other)
Make a Name and give it the range
rnRange = .Range(.Range("A2"), .Range("A65536").End(xlUp))
rnRange.Name = "MyRange"

And in the property for the Combobox (ListFillRange) write the range
name "MyRange"

The the autofill works

EW


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