VBA Code - Message Box

[Busymanjohn]

Hi guys, looking for some help, I have a file which contains some VBA code that shows a Message Box when a number does not appear in a list, I would like to have a Message box appear when the number does appear in the list ,, so basically have a two boxes, one to say, "Does not appear" and another that says "Yes it appears" ,,,, or words to that effect.

 

[Luke M]

It would help if you could show the code you have. Guessing at the layout...

[pre]

If Range("A2") <> 2 Then
MsgBox "Does not appear"
Else
MsgBox "Yes it appears"
End If

[/pre]

 

[Busymanjohn]

Hi, Luke ,, excellent, that works fine. Cheers

 

[Luke M]

Sweet, the psychic skills are on fire today! =P

 

[Marc L]

Fire or Thunder but Mozilla !

(sorry I'm out !)