matt wrote:
On Mar 23, 3:58 pm, "willing2learn via OfficeKB.com" <u32721@uwe
wrote:
On Mar 23, 3:43 am, "willing2learn via OfficeKB.com" <u32721@uwe
wrote:
[quoted text clipped - 20 lines]

- Show quoted text -

I'm not sure why you are getting the run-time error. Here's another
swing at it:

Worksheets("Cover").Shapes("Text Box 1").TextFrame.Characters.Text =
Value1

Maybe this will help, maybe it won't. When I run the code with my
previous post as well as the above line, they both work equally as
well. I'm a bit baffled.

Matt
Hi Matt
Is there any particular event from which you are running your code? Mine is
in a procedure which is part of the entire script. How are you testing this?
If I have a few lines of code then it would seen fine, but because my
routines run for almost a minute my textbox values only appear after all the
code has finish executing.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200703/1