Is there any form to make a cell or merged cells to bigger or shrink its height, depending on how much is written in a textbox(how many lines the textbox has?)
Thanks for the help.
Is there any form to make a cell or merged cells to bigger or shrink its height, depending on how much is written in a textbox(how many lines the textbox has?)
Thanks for the help.
After entering the text into the cell from the text box try using this line of code (change row number to suit)
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
Like this?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks