how to make "OR" work in excel vba code

Hi does anyone know how to make "OR" work in excel vba code, as every time i use it, it never seems to work!:mad

What do you wish to do with it?

Please Login or Register  to view this content.

may be one way.

this is part of my code, which never works correctly

Please Login or Register  to view this content.

Hi jakeembx,
try it

Please Login or Register  to view this content.

If you wish to use Or you must repeat the expression for every value:

Please Login or Register  to view this content.

Select Case is easier for this as nilem has shown.

thank you its kind of work not what i wanted. i did it to go to case select when a cell = 3. code below, could you tell me if i put the right case else etc.. in the right position...

Please Login or Register  to view this content.

A little different:

Please Login or Register  to view this content.

Please Login or Register  to view this content.