keilah
04-02-2008, 06:41 AM
Hi experts
How would i add a message box icon to the following code....
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Value = "" Then
MsgBox ("Invalid Data Input Attempt - Error")
End If
End Sub
need the user to see a STOP and red cross in a circle with the above message......once the message box is displayed and the user click ok to acknownledge the message......he/she still cannot go back and try to enter any data in all balnk/empty cells.....
thanks
How would i add a message box icon to the following code....
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveCell.Value = "" Then
MsgBox ("Invalid Data Input Attempt - Error")
End If
End Sub
need the user to see a STOP and red cross in a circle with the above message......once the message box is displayed and the user click ok to acknownledge the message......he/she still cannot go back and try to enter any data in all balnk/empty cells.....
thanks