alter your entries to formulas similar to this

="this is text " & Sheet3!A1 & " more text"

then in sheet3!A1 put what you want to display: (Name) or BoB

Sheet3 can be hidden if you wish.

--
Regards,
Tom Ogilvy



"jhahes" wrote:


Is there anyway to do the following...

Say I want to replace this

(name)

in every sheet with txtFirstName.value

for example

txtFirstName.value = "Bob"

So every sheet that has (name) in part of the cell will be replaced
with Bob.

But when the worksheet closes put (name) back in and take out Bob.

thanks for any help

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=566792