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