Auto-complete in a dropdown list

andy_g_kitchens · #1 (**permalink**) 02-17-08, 08:28

Hi guys
After creating a great form using Excel and the expertise of Shades I am now wondering if it is possible to have a sort of auto complete in a dropdown list box.
I've done a quick search and found nothing that I can understand!
Kind regards
Andy

MarkReez · #2 (**permalink**) 03-05-08, 07:36

You have to use the combo box which is made available to put on a user form in the vba project - the combo box that you just drop straight onto the spreadsheets from the form controls doesn't have the auto complete property.

andy_g_kitchens · #3 (**permalink**) 03-05-08, 18:42

Ok..thanks for that
How do I do it?

Internet Services

Web Development

Digital Marketing

Consumer Tech