Cell value in text box

[Bill_Green via OfficeKB.com]

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.

 

[Rick Rothstein \(MVP - VB\)]

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]

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!

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.