Excel 2003: VBA to control Header title based on date in cell B3.

[jplink49]

Hello everyone.

Is it possible to control my Header title based on the date in cell B3 (this cell will always be a date)? I want the Header title to display the Month and Year of that date in cell B3; this will be the title.

For example: Cell B3 has 4/1/2008. I want my Header title to display "April 2008".

Likewise: Cell B3 has 11/1/2008. I want my Header title to display "November 2008".

Thanks in advance for any help.

[martindwilson]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

when macro run will add A1 (change to your cell)to the header, you could probably run this as before print

Please Login or Register  to view this content.

don't know how to change format tho'{probably a bit of code could be added ?)

[jplink49]

Thank you MartindWilson!!! This did the trick. As you noticed, I'm new at dabbling in VBA in Excel, but this forums like this makes it easier.