I have a column in G which is for ratings such as R 18 and R 15

In column J is customer names, what I want is to bring up a message t
check ID if that customer below tries to rent a R 18 or R 15 movie..
have tried the following without much luck

Private Sub Worksheet_Change(ByVal Target As Range)

If [j9] = "Thomas Chappell" Then MsgBox "Please check ID befor
renting!"

If [j9] = "Robyn Smith" Then MsgBox "Please check ID befor
renting!"

If [j9] = "Xendan Smith" Then MsgBox "Please check ID befor
renting!"
End sub

this is just basic, but I can seem to check the whole column..Or chec
if they are trying to rent a R 18 :(

Mark

PS..In work sheet 3 I have their date of birth, is it possible to chec
date of birth and if < R 18 or R 15 the message box appears, advisin
themt to make another choice..?? Please help I am getting s
frustrated.

--
Message posted from http://www.ExcelForum.com