Visible text in a cell
How can we get the visible text of a cell so as to be able to move the remaining hidden text in another cell ?
I am getting the text in the said cell from the user using a form interface and would also like to set the max text length of the textbox equal to what is allowed in a cell (max capacity of a cell). The textbox of course is multiline.
Vish - assuming u've looked
Vish - assuming u've looked at wrapping text and autofitting the row (not col).
If I don't want to change the
If I don't want to change the row height...just move the hidden text to the next cell.
why can't you keep it in the
why can't you keep it in the cell and have a button that expands the view into a form if the user wants ?
... splitting to the next cell will be ugly
Visible Text of a cell
It won't show up in the print. The maximum row height in excel is 409 points...and the text I might have in the cell is well beyond the max cell height to show full text.
how about adding the text to
how about adding the text to a shape.. will show up on print, and can be very big