auto fill ComboBox depending on result of another Combobox

[redspanna]

Hi all

as the user inputs data into my userform I would like the following to happen:-

If the user enters the value 0 (zero) or selects this from the drop down menu of ComboBox5 then auto populate ComboBox6 with "n/a"
Else leave ComboBox6 blank

any ideas?

thanks in advance

 

[redspanna]

Kinda got it to work playing around with other code in my workbook

Private Sub ComboBox5_Change()
If ComboBox5.Value = "0" Then ComboBox6.Value = "n/a"
EnableDisableCommandButton
End Sub

any other ideas still welcome