an activeX combobox from the forms toolbar already has this property
(although not exactly as you state).

Look at the MatchEntry property.

--
Regards,
Tom Ogilvy



"¯aczek" wrote in message
...
Hi,

First st of all, sorry for my English :)

Excel has a propery, that he remember last values entered into each
column,
and when user enters new data, excel prompt when first inserted letter is
the same with one of the last enetered data in this column.

Is there any way to give this property to VB comboBox, for example from
column A?

Thanx in advance!

ok, but how to automaticly load data from column i.e. X to this combo?
Is there any mechanizm included in VB or i shold do it myself?



Look at the MatchEntry property.

--
Regards,
Tom Ogilvy

set rng = Range(Cells(1,x),Cells(rows.count,x).End(xlup))
combobox1.List = rng.Value

Would be a guess at what you are asking.

--
Regards,
Tom Ogilvy


"¯aczek" wrote in message
...
ok, but how to automaticly load data from column i.e. X to this combo?
Is there any mechanizm included in VB or i shold do it myself?



Look at the MatchEntry property.

--
Regards,
Tom Ogilvy

thx :)