Linking of Cell value to a text box

  • Thread starter Thread starter sudhanshu
  • Start date Start date
S

sudhanshu

Is it possible to refer a cell and/or more than one cell to a text box?
If yes, please tell me how to do that.

In case it is possible to refer more than one cell to a text box, then
it would require flexible text box. I mean when more data is required
to be put in the same text box, its boundaries should be flexible to
accommodate the data of more than one cell that have been
referenced/linked to the text box.

Please Help.

Thanks in advance
Sudhanshu
 
If you want the value of a cell to appear in a textbox and be linked such that
if the value in the cell changes then the value in the text box will change,
create the text box and then with it selected, type = into the FORMULA bar and
then using the mouse, click on whatever cell you want to link.

You cannot link more than one cell, but you can create a cell elsewhere within
your sheet that links as many cells as you like, and then link to that cell with
the textbox. I don't believe you can have the textbox resize automatically
without using VBA.
 
Thank you Ken

I would request you to let me know how to do automatic resizing of text
box based on data length.

Awaiting for your response

Sudhanshu
 
Back
Top