Message box with VBA when cell selected AND other cell equals "X"

[97hills]

Hi guys, easy one for you. Just need for there to be a pop up box with the message "Warning" whenever I select cell A1 where cell A2 ="X". e.g. if cell A2 does equals anything but "X" then there will be no warning message

Thanks in advance

[Nu2Java]

I think you are looking for something like this, placed in SHEET1 or whatever sheet you need:

Please Login or Register  to view this content.

[97hills]

I think you are looking for something like this, placed in SHEET1 or whatever sheet you need:

Please Login or Register  to view this content.

Thanks Nu2Java, it's almost there.

I need the message box to appear when the cell A1 is selected. e.g. if cell A2 = "X" and I click on A1, I will get the message box at that point.

Sorry for not explaining better

Thanks

[JosephP]

you need the SelectionChange event and not the Change event

[97hills]

you need the SelectionChange event and not the Change event

Simple, thanks!