placeholders

[jhahes]

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

[Tom Ogilvy]

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
>
>

[jhahes]

Hi Tom,

thanks for the solution....it works....however

on some of the cells - it has errors because the text is more than 255 characters and it says formula is too long....Is there an easy way to get around this?


thanks

Josh

[Tom Ogilvy]

Well, you could put sections of that long text on cells on that Sheet3 and
then cocatenate them in

=Sheet3!A1 & " " & sheet3!A2 & " " & Sheet3!A3

perhaps.

or you can go back to your original and try doing Edit=>Replace
What (Name)
With Bob

(with the macro recorder on if you want code).

It seems to me that replace also has problems with long text strings - as I
recall.

--
Regards,
Tom Ogilvy


"jhahes" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Tom,
>
> thanks for the solution....it works....however
>
> on some of the cells - it has errors because the text is more than 255
> characters and it says formula is too long....Is there an easy way to
> get around this?
>
>
> thanks
>
> Josh
>
>
> --
> jhahes
> ------------------------------------------------------------------------
> jhahes's Profile:
> http://www.excelforum.com/member.php...o&userid=23596
> View this thread: http://www.excelforum.com/showthread...hreadid=566792
>

[jhahes]

Thanks, tom for helping me... i will try one of those