Yes it is. I just wrote knocked this nonsense up:

Put a 1 in cells A1
Put this in cell B1
=IF(A1=1,SillyFunction(A1),"Nada")

Put this in a module:
Public Function SillyFunction(strIn As String) As String
MsgBox strIn
End Function

I'd call that starting a bit of code from an IF function wouldn't you? ;o)

"Bob Phillips" wrote in message
...
No it isn't.

You can use conditional formatting to format that cell or event code to pick
up the change and run code based on that change.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Frazer" wrote in message
...
Finally one macro problem solved, so i begin another......

is it possible to start a macro using an IF function


i.e if cell 1 shows a 0, the macro is off, but when it changes to 1 the
macro starts running.....

is this possible??

Thnx for help in advance??