Hi All
In a UserForm i have 2 ComboBoxes.
ComboBox1 List = Sheets("Artikel").Range("A2:A1000")
ComboBox2 List = Sheets("Artikel").Range("B2:B1000")
Both Combo's match each other:
If ComboBox1 = A3 Then
ComBox2 shows B3 etc
ComboBox1 = Sheets("PartsDeliver").Range("D28")
ComboBox2 = Sheets("PartsDeliver").Range("D29")
It would be easier if i could use 1 Combo with 2 Columns where:
Column1 = Sheets("Artikel").Range("A2:A1000")
Column2 = Sheets("Artikel").Range("B2:B1000")
Column1 = Sheets("PartsDeliver").Range("D28")
Column2 = Sheets("PartsDeliver").Range("D29")
I've been trying to set this up but i just can't get it to work!
Anyone who could offer some help on this?
/Roger
In a UserForm i have 2 ComboBoxes.
ComboBox1 List = Sheets("Artikel").Range("A2:A1000")
ComboBox2 List = Sheets("Artikel").Range("B2:B1000")
Both Combo's match each other:
If ComboBox1 = A3 Then
ComBox2 shows B3 etc
ComboBox1 = Sheets("PartsDeliver").Range("D28")
ComboBox2 = Sheets("PartsDeliver").Range("D29")
It would be easier if i could use 1 Combo with 2 Columns where:
Column1 = Sheets("Artikel").Range("A2:A1000")
Column2 = Sheets("Artikel").Range("B2:B1000")
Column1 = Sheets("PartsDeliver").Range("D28")
Column2 = Sheets("PartsDeliver").Range("D29")
I've been trying to set this up but i just can't get it to work!
Anyone who could offer some help on this?
/Roger