HELP!alert when negative number comes in?

[tpete]

Hi,

I am trying write a code that alerts the user when a negative number i
in a cell. This may sound basic but i am just a beginniner at vba's.

Can anyone help?? ;

 

[Judi]

I am not sure about VBA.

However, You can use the cell validation and set an alerts.
To do this click the cell. Click Data on the menubar,
Click Validation, On the settings tab Allow whole numbers
or Decimal, Set data to Greater then or equal to 0, Set
minimum to 0. On the Error Alert type the Tille and error
message that you want.

Hope this helps

Judi