Alerting myself

N

Neuther

Is there a way to give your self alerts?

I played with valadation some but it won't work w/ a formula.

Is there any way to alert myself that the answer to a formula i
another worksheet has gone outside my aragned value.

What i tried doing in valadation was this

=SUM(Lookup!J287:M287)-(COUNTA(G4:G47))>0

but that doesn't work. Is there some way to make it work so that i
the above happens i get an alert of some kind. Also i'm working i
multiple worksheets so i would like it if it would tell me no matte
what worksheet i was in
 
R

routeram

Hi,

I could think of the following.

Select a cell and enter the following.
=if(yourcriteria, "Error", "No errors")

i.e cell shows "Error" when your range is exceeded, "No errors
otherwise.

Assign a cell name "error" to it.

Now right click the sheet tab where the cell is and enter this.

Private Sub Worksheet_Calculate()
If Range("error") = "Error" Then
MsgBox ("Alert message! Error! ")
End If
End Sub

I can't think of any way without a little coding.

Regards,
Ra
 
N

Neuther

so i tried that and couldn't get it to work. It was a good idea so
did this

Private Sub Worksheet_Calculate()
If Cells(3, 2).Value >= 1 Then
MsgBox ("New Feat")
End If
End Sub

which work's and does what i want however it only work's when i pus
the play button. is there anyway to get it to play a macro w/out
button or something
 
F

Frank Kabel

Hi
you have to put this code in your worksheet module and not in a
standard module. To go there try the following:
- right click on your worksheet tab
- choose 'View Code'
- paste your code
 
Top