Just to make it a bit more complex... what if I had another drop down list in another column On the same worksheet... say column G that need to be entered if there is a value in column F... what would the code be: (ill have a go but could you pllease correct it mate)
[VBA]Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i As Long
Dim LastRow As Long
Dim Prompt As String
Dim Title As String
If Target.Column <> 3 Then
LastRow = Range("B" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Range("B" & i).Text <> "" And Range("C" & i).Text = "" Then
Prompt = "You must enter a value in " & Range("C" & i).Address(False, False) & "."
Title = "Additional Information Required"
MsgBox Prompt, vbCritical, Title
Exit For
End If
Next i
End If
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim i As Long
Dim LastRow As Long
Dim Prompt As String
Dim Title As String
If Target.Column <> 7 Then
LastRow = Range("F" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Range("f" & i).Text <> "" And Range("C" & i).Text = "" Then
Prompt = "You must enter a value in " & Range("f" & i).Address(False, False) & "."
Title = "Additional Information Required"
MsgBox Prompt, vbCritical, Title
Exit For
End If
Next i
End If
End Sub
End Sub [/VBA]
how did I go?? could you correct me please... thankyou soooooo much