combo box default value

[jtodd]

I have a form with 2 combo boxes, I would like what is selected in the first box to apear in the second but still have the option to change the data in the second box ie
if the user selects "Jim" in the first box "Jim" appears in the second box , the user can then either leave "Jim" in both boxes or select a different name in the second box.

So there would be a primary name and a secondary name but if they were the same the user would not have to change the second name.

Hope this makes sense??

 

[My Aswer Is This]

Try This:

Private Sub ComboBox1_Change()
ComboBox2.Value = ComboBox1.Value
End Sub

 

[jtodd]

Try This:

Private Sub ComboBox1_Change()
ComboBox2.Value = ComboBox1.Value
End Sub

So simple , thanks for taking the time

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance. Take care