Thread: Embeddding a macro in Logical IF stmt
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Embeddding a macro in Logical IF stmt
Hi ron

You posted private that you use it in a formula
Try to use the calculate event in the Sheet module

This example will run the macro "YourMacroName" If the formula cell B1 display a value
higher then 10

Private Sub Worksheet_Calculate()
If Me.Range("b1").Value 10 Then
YourMacroName
Else
'do nothing
End If
End Sub

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi

Do you mean a IF statement in a formula or in code?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron" wrote in message ...
Hi,

I am trying to embed a macro in a logical IF statement in the true result. Is this even possible, and if so how?

Thanks for your help!




Reply With QuoteReply With Quote