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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonine - 18 Jun 2007 17:02 GMT

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

Reply to this Message

Gary''s Student - 18 Jun 2007 17:34 GMT

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.

Signature

Gary''s Student - gsnu200731

Reply to this Message

Jonine - 19 Jun 2007 14:42 GMT

It worked perfectly! Thank you so much.

> In A1 put:
> TV
[quoted text clipped - 15 lines]
> If the user attempts to enter their name in A2 prior to entering the moving
> title in A3, the action will be rejected.

Reply to this Message

Jonine - 19 Jun 2007 18:05 GMT

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.

> In A1 put:
> TV
[quoted text clipped - 15 lines]
> If the user attempts to enter their name in A2 prior to entering the moving
> title in A3, the action will be rejected.

Reply to this Message