Thread: If statements and macros
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Patrick Dave Patrick is offline
external usenet poster
  
Posts: 249
Default If statements and macros
Sure

If Range("A1").Value = 1 Then
Range("C1").Interior.ColorIndex = 3
Else
Range("C1").Interior.ColorIndex = 5
End If

(though you wouldn't need a macro for this)

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"bmorganh" wrote:
| Is it possible for an "if" statement to initiate a macro?


Reply With QuoteReply With Quote