How can pick value in ComboBox1-Connected sheet2!A1:A3 and
pick value in ComboBox2 Connected sheet2!B1:B8 and
match the value of ComboBox1 in Column C
match the value of combobox2 in Column D
and give me in ComboBox3 the dates in E:H

using this horizontal line but not knowing the exact source.

dim myCell as range
dim myRng as range

set myrng = worksheets("sheet2").range("e2:h2")

With me.combobox3
for each mycell in myrng.cells
..additem mycell.value
next mycell
end with


--
ca1358