Can u link word art to cell value

[Alpacino]

I have a wordArt on a sheet with "Week:" in it I would like a number in the word art to be linked to a cell that changes number value to the display changes whenever the cell changes value e.g cell D5 is "3" then wordart says "Week 3"

Is this possible to do???

 

[indiantrix]

Using Excel 2007, Insert Tab, WordArt, then when you see a box that says "Your Text Here", ignore it. Click into the formula bar just above your worksheet and type, for example, "=G4" without the quotation marks.
Then the WordArt will be linked to cell G4, and will reflect its contents dynamically.
Hope this can help.
Larry.

 

[MickG]

Try:-

ActiveSheet.Shapes("WordArt 2").TextEffect.Text = "Week " & [D5]

or

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "D5" Then
ActiveSheet.Shapes("WordArt 2").TextEffect.Text = "Week " & Target
End If
End Sub

Mick

 

[Robert Mika]

Two steps solution

A1: 5
A2: Custom Format: "Week "##
link A2 to A1: =A2=A1

use WordArt and then in" Insert function" link this art to A2.
You will get "Week 5".
Change value of A1 - that will reflect the number in Word Art.