Try this it tests A6
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A6").Value = 0 Then MsgBox ("Value = 0")
End Sub
--
David
"Scarecrow" wrote:
Im new to excel and have just been finding out the basics of macros. Can
anyone tell me how to make a message box appear when a certain cells
value reaches 0?
--
Scarecrow
------------------------------------------------------------------------
Scarecrow's Profile: http://www.excelforum.com/member.php...o&userid=35364
View this thread: http://www.excelforum.com/showthread...hreadid=551335