Two options needed in one line of code

[ipbr21054]

Hi,
In my CoboBox5 there are various options.
Two of them need to show N/A

Ive done the below which works fine BUT as opposed to making a duplicate how can i also have another paramater in the same line.

Basically i need N/A applied to a worksheet cell if HISS CABLE ONLY or CLONE ONLY was selected
So like this example
If Me.ComboBox5.Value = "HISS CABLE ONLY" or "CLONE ONLY" Then



Here is the code.

      If Me.ComboBox5.Value = "HISS CABLE ONLY" Then
      .Cells(8, 8).Value = "N/A"
      End If

 

[nemmi69]

If Me.ComboBox5.Value = "HISS CABLE ONLY" Or Me.ComboBox5.Value = "CLONE ONLY" Then
      .Cells(8, 8).Value = "N/A"
End If

 

[ipbr21054]

I then get a compile error see screen shot

 

[ipbr21054]

See this of which doesnt give me any errors etc BUT when CLONE CHIP ONLY is selected it is supposed to enter N/A in row 8 cell 8 but when i check its empty.

If i select HISS CABLE ONLY then i do see N/A but my goal is N/A for either selection

Private Sub ComboBox5_Change()
      With Worksheets("MCLIST")
      
If Me.ComboBox5.Value = "HISS CABLE ONLY" Then
      .Cells(8, 8).Value = "N/A"
      
ElseIf Me.ComboBox5.Value = "CLONE CHIP ONLY" Then
      .Cells(8, 8).Value = "N/A"
      
End If

End With
   If ComboBox5.Value = "HISS CABLE ONLY" Then
      Label9.Visible = False
      ComboBox8.Visible = False
      
   ElseIf ComboBox5.Value = "CLONE CHIP ONLY" Then
      Label9.Visible = False
      ComboBox8.Visible = False
      
End If
   
End Sub

 

[nemmi69]

Did it have the With Worksheets("MCLIST")?

With Worksheets("MCLIST")
    If Me.ComboBox5.Value = "HISS CABLE ONLY" Or Me.ComboBox5.Value = "CLONE ONLY" Then
          .Cells(8, 8).Value = "N/A"
    End If
end with

 

[ipbr21054]

I had to add that to then stop the error message