Thanks
One more question. The target cell should all ways be text. Is there any
other change I should use?
Sure appreciate the responce

"Bernie Deitrick" wrote:

Curt,

Your comparison

Target.Value <= 0

will get you in trouble, if target.value is actually text. Try:

If Target.Column = 12 And CDbl(Target.Value) <= 0 And IsText(Target.Value) Then _
Call Announcer(Target)


HTH,
Bernie
MS Excel MVP


"Curt" wrote in message
...
= isText
If Target.Column = 12 And Target.Value <= 0 And IsText(Target.Value) Then _
Call Announcer(Target)
used to working with numeric blanked on this text issue
isText was isNumeric
does this look right
Thanks