how to created userform with combobox and listbox
combobox have 3 option to select (Number,Colour and Name)
and the listbox will show about 3 different of data
Number data :1001,1002,1003,1004,1005
Colour data :Black,Blue,Red,Yellow,Green
Name data : Jhonson,Robert,Tina,Sabrina,Leonardo
so when i choose Number on combobox ,the Listbox will show me data 1001,1002,1003,1004,1005
but when i choose Colour ,listbox will show me Black,Blue,Red,Yellow,Green
and then Name will show Jhonson,Robert,Tina,Sabrina,Leonardo
ok i put data on
sheet1 like this
Coloumn A1 :Number B1 : Colour C1 : Name
A2 :1001 B2 : Black C2 : Jhonson
A3 :1002 B3 : Blue C3 : Robert
A4 :1003 B4 : Red C4 : Tina
A5 :1004 B5 : Yellow C5 : Sabrina
A6 :1004 B6 : Green C6: Leonardo
And i post my sample worksheet
Thanks for your help.
Bookmarks