Excel Data validation

J

jeff

Hi,

Using two combo boxes with this code; listfillrange
properties are paired as such: (sorry I used abbreviations
for your DDIs.)
jeff


H I
Albania AL
Botswana BO
France FR
Germany GE


Private Sub ComboBox1_Change()
ComboBox2.ListIndex = ComboBox1.ListIndex
End Sub
Private Sub ComboBox2_Change()
ComboBox1.ListIndex = ComboBox2.ListIndex
End Sub
 
Top