Combo Box

**chelseajosephine** · 12-09-2013, 03:55 AM

Hi.

I need help for combo box, for my inventory program :
1. How to make two combo boxs related one with other , example : if i choose my category for "Seafood "in combo box "Category" , so the list of item "seafood" will appear in combo box "Item"

2. If i want to choose one item in combo box, by type one or two characters , it will give me a suggestion of item contain those characters ( search automatic ) .

Thanks for solution.

Regards,
Chelsea

**Bhuvi** · 12-09-2013, 06:01 AM

Hi chelseajosephine,

Welcome to the forum

the automatic search can also be attained through data validation feature of Ms excel.

I can't help much by combo boxes but in the attaced file is an alternative.

You can change the names as per your requirement.

<If this helped, pls click on the star below this post to add some reputation>