Change textcolor in header by using a macro

**EliseV** · 01-07-2015, 07:58 AM

Hi!

When I run this macro, I want it to change the color of the text in the header into .Color = -10659502.
I've tried several things to code it correctly, but as a beginner in VBA programming, I can't figure out how to code this.

This is my code, and it works

, I only need to find a way to also change the color of the text ..

Sub Macro2()
    Sheets("Offerte").PageSetup.LeftHeader = "&""ITC Avant Garde Gothic Medium""&24Offerte " + Sheets("Werkbrief").Cells(1, 2)
End Sub

I hope someone can help me out!

**protonLeah** · 01-07-2015, 08:04 PM

    Dim hdrString As String
    hdrString = "&""ITC Avant Garde Gothic Medium""&24&KA2A6AEOfferte " + Sheets("Offerte").Cells(1, 2).Value
    Sheets("Offerte").PageSetup.LeftHeader = hdrString

10659502₁₀ = A2A6AE₁₆