This works great for one cell - thanks. But, there are 6 T.V. and 8 periods
that I need to use the same code for. Different teachers will be adding their
names to the list as the day goes on. It there anyway to make this work each
time the list is activated for the different periods and TVs?

I tried adding the other cells to the range, and it works, but if the
information is provided in an earlier cell, the formula figures it is done
and doesn't work on any of the other ones.

"Gary''s Student" wrote:

In A1 put:
TV
In A2 put the validation list dropdown
In A3 the users should enter the name of the movie

In worksheet code enter:

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A2")) Is Nothing Then Exit Sub
If Target.Offset(1, 0) = "" Then
Application.EnableEvents = False
Target.Value = ""
Application.EnableEvents = True
MsgBox ("Movie title must be entered first")
End If
End Sub

If the user attempts to enter their name in A2 prior to entering the moving
title in A3, the action will be rejected.
--
Gary''s Student - gsnu200731