excel16, autocomplete drop-down list

hi,
can u pls help, ive created 2 combo box and added some codes in attached excel for autocomplete drop down.
combo box to be added in cells b2 (country) and b3 (name) instead of the drop down validation list.
Or is there another alternatives to do that?

The combo shoud take values of the dropdown sheet and populate cell c2 & c3 after combo box selection.
values in cells status to be populated according to the selection done.

Pls help

Hi Akika,

I will always recommend that you use ActiveX Controls rather than Form Controls. In my opinion, it's easier to call the property names when using VBA codes.

yes that right .. thxs a lot its working

hi,
in the attached combo box for the vba's, how is it possible to default a particular country in the list e.g Canada
but we should be able to change to another country from the list.

Any idea?

Use either workbook activate or worksheet activate to set default - post in appropriate module

Please Login or Register  to view this content.

thanks a lot for ur help

hi,
how can i lock the drop-down values .. to prevent from deleting the value after selection?

ive used combobox Style property to 2-fmStyleDropDownList.. and its ok.