How to deate Conditional statement for the header
 

I have been task to have an image appear in the Header if a cell contains a
value. For instace if A8 is not null then have "SOLD" appear in the header.
I am not use to programming in Excel. I usually work with Access. So if you
could lead me through this I would appreciate it . I am using office 2003

Thank you

How to deate Conditional statement for the header
 

On 11 Jan, 16:25, WuiChi wrote:
I have been task to have an image appear in the Header if a cell contains a
value. *For instace if A8 is not null then have "SOLD" appear in the header.
I am not use to programming in Excel. I usually work with Access. *So if you
could lead me through this I would appreciate it . * *I am using office 2003 *

Thank you

Hi


Something like the following maybe:

With Sheets("Sheet1")
If Not IsEmpty(.Range("A8").Value) Then
.PageSetup.LeftHeader = "SOLD"
End If
End With

Richard