Creating a variable word art

**jwongsf** · 01-23-2009, 08:26 PM

Hi Gurus"
I am wondering if anyone as created a what to do word art, using a input variable.I.e in may example I have a person, Suzie Smith who is an Chief Manager, when I box requires her signature, I would like for it eo be imprinted going diagonal across the box. Is this possible?
Thanks, James

**shg** · 01-23-2009, 08:33 PM

Select cell A4, and in the Names box, left of the formula bar, type Name.

Select the wordart, and in the formula bar, type =Name

**jwongsf** · 01-24-2009, 09:08 PM

You lost me, I understand that you want me to name the Cell A4 however, when I select the wordart it is not formula bar only the TEXT Box.How to I get the word arts that you are talking about, I selected the "Drawing" from the tools but got the wordart gallery.
thanks

**shg** · 01-24-2009, 11:49 PM

Don't double-click it, just select it.

**jwongsf** · 01-25-2009, 11:24 PM

I only click on it once and it took me to the Gallery to choose the word art. I want, can you create it in the file and post the file?
Thanks
James

**shg** · 01-26-2009, 12:25 AM

See attached. Change A4.

**jwongsf** · 01-26-2009, 11:08 AM

Thanks, it works for a single line, have you get it to work for multi-lines too?

**Andy Pope** · 01-26-2009, 11:40 AM

Build the text in a single cell and link to that,
so for your example this in A5

=A4 & " " & B4

Creating a variable word art

LinkBack

Thread Tools

Rate This Thread

Display

Creating a variable word art

Re: Creating a variable word art

Re: Creating a variable word art

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions