Hi there,
Looking for help on a custome user form.
Have a drop down controll that with 3 values hard coded in (ie JAX,TIZ,OAP)
Based on the selected item from the above code, I want to fill a list box with associated items (from a range with in the workbook ie sheet1 A1:B10-A1:A10 being one of the 3 hard coded items, b1:b10 being the related items.
I've tried ListBox1.AddItem from the help files, but seem to be getting no where fast.
Any clues on this one?
Thanks in advance
Matt
Looking for help on a custome user form.
Have a drop down controll that with 3 values hard coded in (ie JAX,TIZ,OAP)
Based on the selected item from the above code, I want to fill a list box with associated items (from a range with in the workbook ie sheet1 A1:B10-A1:A10 being one of the 3 hard coded items, b1:b10 being the related items.
I've tried ListBox1.AddItem from the help files, but seem to be getting no where fast.
Any clues on this one?
Thanks in advance
Matt