Good morning,
I would appreciate some help with the following: a macro that runs whe
a certain value is reached in a particular cell. How can I programm
such "if" command?
Thank you in advance.
Fernand

--
fernideme
-----------------------------------------------------------------------
fernidemex's Profile: http://www.excelforum.com/member.php...fo&userid=1540
View this thread: http://www.excelforum.com/showthread.php?threadid=27038

Use worksheet_change macro.
If cells(x.y) = xxxx Then

Sharad
"fernidemex" wrote in message
...

Good morning,
I would appreciate some help with the following: a macro that runs when
a certain value is reached in a particular cell. How can I programme
such "if" command?
Thank you in advance.
Fernando


--
fernidemex
------------------------------------------------------------------------
fernidemex's Profile:
http://www.excelforum.com/member.php...o&userid=15402
View this thread: http://www.excelforum.com/showthread...hreadid=270381

Hi Fernando

Rightclick the sheet tab, choose "View code", paste this in the module that
shows up:

Private Sub Worksheet_Calculate()
If Me.Range("A1").Value = 100 Then
Call ActionMacro
End If
End Sub

and either in a standard module or in the same sheet module, paste this:

Sub ActionMacro()
MsgBox "Format C:\ now ?", vbYesNo + vbQuestion
End Sub

(Note: The worksheet in question must contain at least one formula,
otherwise the Calculate event won't start.)

HTH. Best wishes Harald


"fernidemex" skrev i melding
...

Good morning,
I would appreciate some help with the following: a macro that runs when
a certain value is reached in a particular cell. How can I programme
such "if" command?
Thank you in advance.
Fernando


--
fernidemex
------------------------------------------------------------------------
fernidemex's Profile:
http://www.excelforum.com/member.php...o&userid=15402
View this thread: http://www.excelforum.com/showthread...hreadid=270381