How to deate Conditional statement for the header

[WuiChi]

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

 

[RichardSchollar]

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 ifyou
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