If ComboBox help please

[adamtate94]

Hi

I have a combobox on my form which data source is a lookup table in the format:
1 String1
2 String2
3 String3
4 String4
5 String5


I want an event to happen only when the combobox has the values 3 and 4 selected, can i have help with the syntax?
I have tried ' If cmbType.Column(0) <> 3 or 4 then ...' but it does not work.

[ItsMe]

Do you want to test for the condition where 3 AND 4 are selected? This is not possible using a Combo. If you want to test for 3 OR 4, you can use the or operator. You only need to use complete statements on each side of the OR operator.

If cmbType.Column(0).Value = 3 OR If cmbType.Column(0).Value = 4 Then
msgbox "Found either 3 or 4."
else
msgbox "3 or 4 was not found."
end if