Some cells in the underlying sheet have a large amount of text, some have maybe 2 or 3 lines. Is there a way
to tell Excel to resize Userform1 and Textbox1(keeping both in proportion) so that all of the text will be displayed ? If the text length is greater than
the size the userform can accomodate on the screen, just set a limit on the maximum Textbox and userform size and include a
vertical scrollbar for these amounts of large data.
I know I may be asking a lot, but from what my limited knowledge tells me, this should be achievable.
The userform would continually be changing size as the user moves from record(row) to record(row)
Thanks for anyone's help.
cr
to tell Excel to resize Userform1 and Textbox1(keeping both in proportion) so that all of the text will be displayed ? If the text length is greater than
the size the userform can accomodate on the screen, just set a limit on the maximum Textbox and userform size and include a
vertical scrollbar for these amounts of large data.
I know I may be asking a lot, but from what my limited knowledge tells me, this should be achievable.
The userform would continually be changing size as the user moves from record(row) to record(row)
Thanks for anyone's help.
cr
