View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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