Can i activate a macro from an IF statement?

  • Thread starter Thread starter grievesy
  • Start date Start date
G

grievesy

I want to run a macro if an IF statement in a cell is true. I thin
this is possible.

I have written the macro and tried using --
IF(n11>o11,MARCONAME(),0)
but i get "that name is not valid."

please help..
 
Hi
what kind of macro do you want to run?
- a user defined function: just insert it
- a procedure which also changes other cells: you have to use an event
procedure for this
 
Thank you for your help..

Can you explain a event procedure.

I have put the macro in a public sub but it still doesn't work.
 
Thank you for your on going help.. i have looked at the website you gav
me and i am not sure if it will work but i am going to try.

Basically, i am using rtd to update certain values. i comapre 2 o
thoses values and if they equal a certain amount i want to run a scrip
that changes some other cells.
Public Sub sellordermodify()
Dim sellprc
sellprc = [m13].Value

Dim MyEccoApp As New Ecco.Application
MyEccoApp.OrderBook.ModifyPrice [d25].Value, sellprc

[b25].Value = sellprc
[e25].Value = time

End Su
 
Back
Top