Combo Box Default

[CrustyR1]

I have a spreadsheet that has multiple combo boxes in it so the user can pick from a list.

Is there a way the selection in the first combo box can be the default value in another / multiple box? However, if the second or third box needs to change the user can override the default & choose something different from the list.

Hope this makes sense.

 

[6StringJazzer]

This can be done with a macro. Are you already using macros in this file? Are the values in the first combobox already in the lists for the other combobox, or would it be a user-defined value?

Are you using Form controls or ActiveX controls? Here is the code to do this with ActiveX comboboxes, although of course, I haven't tested with your specific scenario:

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

 

[CrustyR1]

This can be done with a macro. Are you already using macros in this file? Are the values in the first combobox already in the lists for the other combobox, or would it be a user-defined value?

Are you using Form controls or ActiveX controls? Here is the code to do this with ActiveX comboboxes, although of course, I haven't tested with your specific scenario:

Private Sub ComboBox1_Change()

   ComboBox2.Value = ComboBox1.Value

End Sub

Thanks for your help 6StringJazzer.

Yes I have changed the form combo to ActiveX combo boxes. The default works a treat. It also let the user override the default in needed.