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!