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