How to make a cell required if another cell has text in it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a group of users in a list. If they book a TV (by choosing their name
under the equipment), I want to force them to add what movie they are
planning to show in the cell below their name before they can book the TV.

I am a newbie at this and a little confused with the variety of macros.

Thanks
 
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.
 
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.
 
Back
Top