Can Word Art be based on a formula?

[Robyn]

I have a calendar file which is just for personal use. However, I like it to look nice as I use the current month on my desktop. Sometimes I play with word art in the month heading ("October 2011", etc.), but I do it manually. The start date of the month (10/1/2011) is calculated in Cell D3. When not using word art, the heading references this cell and is custom formatted to show the month spelled out plus the year. If I take this formula out and put word art with the formula =D3, what I get is a calendar showing "=D3" instead of the month and year. Is there a way for word art to use a formula to return the calculated value of a formula? (I am using Excel 2003.) Thanks for any help (or for the information that this is impossible in my version - or any version - of Excel).

 

[Scott Huish]

You could do something like this in the Worksheet Calculate Event:

Private Sub Worksheet_Calculate()
    ActiveSheet.Shapes("Rectangle 1").TextFrame2.TextRange.Characters.Text = Format(Range("A1"), "mmmm yyyy")
End Sub

Change Rectangle 1 to whatever the name of the WordArt you want to change is.

 

[Robyn]

Ah, my old bugaboo. Someday, when I get around to learning VBA...

I will keep your suggestion inside my calendar file, awaiting that day.

Thank you!

Robyn