charly1988
New Member
- Joined
- Jul 31, 2022
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
I have a sheet for items, with 4 columns (ItemCode, ItemName, Type and Country). I have named it has ITEM_TABLE in the named range.
In my userform i have a textbox which says the country name when the userform initialize. so what i want is According to the country name the combo box has to show the items which belongs to that country.
ItemCode ItemName Type Country
ITM01 D_Item01 box Dubai
ITM02 I_Item01 bag Iran
ITM03 D_Item02 box Dubai
ITM04 I_Item02 bag Iran
textbox : Dubai
Combobox : D_Item01
D_Item02
In my userform i have a textbox which says the country name when the userform initialize. so what i want is According to the country name the combo box has to show the items which belongs to that country.
ItemCode ItemName Type Country
ITM01 D_Item01 box Dubai
ITM02 I_Item01 bag Iran
ITM03 D_Item02 box Dubai
ITM04 I_Item02 bag Iran
textbox : Dubai
Combobox : D_Item01
D_Item02