How to make a cell required if another cell has text in it
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
|