message box

Hi,

can you be more specific? I can only offer vague advice with your description.

You should use the worksheet_change event and the MsgBox function. Something like this:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 1 Then ' <-- this is the column you check
    If Target = "1" Then MsgBox "You entered 1."
    If Target = "2" Then MsgBox "You entered 2."
    If Target = "3" Then MsgBox "You entered 3."
    If Target = "4" Then MsgBox "You entered 4."
End If

End Sub

You need to write the code in the worksheet's code window. Change it the way you like.