View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

No, functions can return a value, they cannot change the format or run a
macro.

You can use event code to do it, but not a worksheet function.

--

HTH

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


"filo666" wrote in message
...
1. There is some way to make that excel, starting from a conditional
structure in a cell, execute automatically a macro???

Something like this:
A B
1
2 1 =if(A2=1,macro1(),macro2())