Just be advised that you would be restricted to many severe limitations
imposed on code called from a cell.
Also, as long as the condition is met, each time there was a calculate, the
code would be executed.
--
Regards,
Tom Ogilvy
Edwin Tam wrote in message
...
Sure. You can. Let's create the following two simple macros. One is custom
worksheet function, the second on the a subroutine which pops up a msgbox.
Function testing()
hello_macro
End Function
Sub hello_macro()
MsgBox "hello"
End Sub
In cell B1, you type the following formula:
=IF(A1="ABC",testing(),"")
Change cell A1 to see the effect.
----- ian123 wrote: -----
Is it possible to use an IF statement in cell b1 to launch a desired
macro if a1 equals the value specified in the IF statement?
ie say IF a1 = "ABC" then the IF statement in b1 would recognise this
and launch macro1?
Does anyone know if this is possible or impossible? It would be
fantastic to learn that its possible!!!
---
Message posted from http://www.ExcelForum.com/