column hint

[¯aczek]

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!

 

[Tom Ogilvy]

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

Look at the MatchEntry property.

 

[¯aczek]

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?

 

[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

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?

 

[¯aczek]

thx