Hi,

I have a problem in excel..

I have

ComboBox1 which contains A, B, C, D. and ComboBox2 which I want to
dynamically changed based on the choice made in ComboBox1. ComboBox1 is
already a filtered selection of column A

A1 A2 A3

A Catagory 1 Release a
A Catagory 2 Release b
A Catagory 3 Release c
B Catagory 1 Release a
B Catagory 2 Release b
C Catagory 1 Release a
D Catagory 1 Release a


So when I choose A in ComboBox1 I want combobox2 to show a
concatination of A2 and A3.

i.e "A" Selected in ComboBox1,
"Catagory1 - Release a",
"Catagory2 - Release b",
"Catagory3 - Release c",

Will appear in comboBox2

Can anyone help ?

Many Thanks
Matt


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/