How does C28 get to be "Remind"?

I will assume a calculated formula.

Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("C28")
If .Value = "remind" Then
Call Macroname
End If
End With
stoppit:
Application.EnableEvents = True
End Sub

The is sheet event code. Right-click on the sheet tab and "View Code"

Copy/paste into that module.


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 10:16:10 -0800 (PST), wrote:

I am trying to write code that will call a macro when the value of
cell is equal to a defined text.

Example:

If C28 = "Remind", then Call Macro_Name.

Can anyone help?

Thanks!