Generate Pop-up Based On Specific Value

Re: Generate Pop-up Based On Specific Value

How about this in the appropriate sheet module:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column <> 7 Then Exit Sub
    If Target.Count > 1 Then Exit Sub
    If Target = "Dispatch" Then
        MsgBox "Hello"
    End If
End Sub

Re: Generate Pop-up Based On Specific Value

This beginner understands everything except

If Target.Count > 1 Then Exit Sub

What is "target.count"

Thanks!

Re: Generate Pop-up Based On Specific Value

It is counting the number of cells in Target - the selection. If it's greater than 1 it exits, because you only want the code to work on one cell at a time.