| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro in formula with "if" condition
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run macro in formula with "if" condition
Only by using worksheet event code like
Private Sub Worksheet_Calculate() On Error GoTo stoppit Application.EnableEvents = False With Me.Range("A1") If .Value = 123 Then Call macroname End If End With stoppit: Application.EnableEvents = True End Sub Gord Dibben MS Excel MVP On Wed, 23 Sep 2009 22:20:03 -0700, wg wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a formula to "go to" another cell if a condition is true? | Excel Discussion (Misc queries) | |||
| Using "protection" as a macro condition | Excel Programming | |||
| Can I condition format, "if the cell contains a formula" | Excel Worksheet Functions | |||
| "IF Condition" formula.... any help plzzz?! | Excel Discussion (Misc queries) | |||
| If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming | |||
Linear Mode
