Hi,
Can anyone help adapt this code so that if something other than N/A is selected it will select option 1. for comboBox44/45?
Private Sub ComboBox25_Change() If Me.ComboBox25.Value = "N/A" Then Me.ComboBox45.Value = "N/A" Me.ComboBox44.Value = "N/A" ElseIf (ComboBox25.Value) = "'anything other than the above" Then Me.ComboBox45.Value = "OPTION 1" Me.ComboBox44.Value = "OPTION 1" End If End Sub
Bookmarks