kicking off a prompt box requiring input when any cell in column C is keyed in

  • Thread starter Thread starter AlanN
  • Start date Start date
A

AlanN

I'm exploring the possibility of having a prompt box pop up when any cell has data keyed in it in column C.
For instance if Column C was requiring and answer such as Yes/No and "yes" was keyed in (or selected from a drop down box), how could I bring up a box that would force the entering on required data in the adjacent columns D:F?

TIA, AlanN
 
Hi
what do you mean with 'force'?
To prompt a messagebox you may ttrigger the worksheet_change event. Put
the following code in your worksheet module:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("C:C")) Is Nothing Then Exit Sub
With Target
if .value = "Yes" then
msgbox "Don't forget to enter data in the other columns"
end if
End With
End Sub
 
Back
Top