Jeez.........having a bad day.
"ListColorIndexes" will of course be adjusted to your macroname.
Gord
On Mon, 14 Feb 2005 15:26:29 -0800, Gord Dibben <gorddibbATshawDOTca wrote:
A formula cannot run a macro.
Event code behind the worksheet could be used to run a macro when a cell
reaches a specific value.
Private Sub Worksheet_Calculate()
On Error GoTo enditall
Application.EnableEvents = False
If Range("$B$3").Value = 123 Then
ListColorIndexes
End If
enditall:
Application.EnableEvents = True
End Sub
Right-click on a sheet tab and "View Code"
Copy/paste the above in there.
Gord Dibben Excel MVP
On Mon, 14 Feb 2005 14:51:05 -0800, Nevaeh
wrote:
Is there a way where I can enter a formula to run a macro? For example could
I enter a formula that say "if this value is greater than or equal to run
this macro".
|