Well aren't you sweet! Such a polite fellow. I didn't post the code I
mentioned, but other than that it would seem "the cell it needs to reference
changes each month" would give you a clue what I was after, but perhaps not.
Thanks anyway, I figured it out. Have a great evening!

Rick Rothstein (MVP - VB) wrote:
Re-read the message you posted... do you really think you gave any where
enough information for someone to work up an answer for you given that they
have no idea what your worksheet looks like? Details... we need details. A
couple of examples: You say "the cell it needs to reference changes each
month"... is there some "rule" governing how or why it changes? What do you
mean by "as it [the text box] moves along the sheets"? More than one sheet?
Moves?

Rick

Hello all,
I have 10 text boxes that needs to draw data from a worksheet into a text
[quoted text clipped - 9 lines]
scroll
across. Is this possible? I appreciate any help.

--
Message posted via http://www.officekb.com