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


"Bill_Green via OfficeKB.com" <u45230@uwe wrote in message
news:886f825af998a@uwe...
Hello all,
I have 10 text boxes that needs to draw data from a worksheet into a text
box
on a UserForm. The problem I have is that the cell it needs to reference
changes each month. I have some coding that changes some formatting based
on
the date (see below) but I need the text box to show the correct value as
it
moves along the sheets. This is a wide spreadsheet, and the boss man wants
to
be able to quickly scan the numbers for any issues without having to
scroll
across. Is this possible? I appreciate any help.

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