#1
|
|||
|
|||
Can you dynamically size a row to fit a Text Box
I am designing a budget spreadsheet that has a series of sections that show budget numbers. On the heading of each section, there is a place for a description of the services. They want the description to span across several columns for reporting purposes. I am trying the use of a text box. Merging cells does not work because that messes up other things.
The text box works fine but because each description is different, the text boxes end up being different sizes. This sometimes makes the box cover important data on the spreadsheet which is not good. Is there a way via a macro or VBA where I can re-size the row height, where the Text box starts, to fit the entire text box? Ideally, I would add the text boxes into the design of the spreadsheet and users would type in the appropriate description and the Text box would automatically be sized so that all the text would show. (That part I have accomplished) But sometimes the text box covers rows that hold financial data and that cannot happen. I would like to have a way so users can automatically fix this issue by expanding the row so that the height of the row matches the height of the text boxes. Is there any way to do this? I feel I am so close but do not know how to get the text box and the spreadsheet row in sync. Any ideas appreciated. |
#2
|
||||
|
||||
Best attach a workbook (free from sensitive data) with this and point us to where in the code and the sheets you want this to work.
|
Tags |
macro - variable area, row height, text box |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete all text except text of a certain font size | nhcowboy1 | Word VBA | 5 | 03-19-2018 02:18 PM |
word 2002 fix text box size | anon125 | Word | 3 | 03-24-2016 10:39 PM |
Text display size is too small | jim999 | PowerPoint | 1 | 01-02-2015 02:55 AM |
Deleting all text except text of a certain font size | JustAboutNoon | Word VBA | 3 | 10-09-2014 10:21 AM |
size or scaling of text? | bkersh | PowerPoint | 1 | 09-05-2010 03:02 AM |