Resizing Cells to Match Inserted Text Box

[wbm4x5220]

Is it possible to get the row that includes an inserted Text Box to autosize to match the height of that Text Box? The text box will vary in height due to word wrapping, but remain a fixed width. Any help would be appreciated.

[scott.s.fower]

hope this works for you

Please Login or Register  to view this content.

[wbm4x5220]

Hi Scott,

Thanks for your help. This works great when inserted into a macro. Any way to get this code to fire automatically when any change is made to the text box contents? I might be able to get a few of my colleagues to remember/understand how to use a macro, but it would work much smoother if they didn't have to do more than enter their text and click out of the box.

[scott.s.fower]

I can't figure it out, for userform textboxes it is possible with the Textbox2_Change() as the macro name, but I tried it on the worksheet1 code and it doesn't work, sorry

[wbm4x5220]

While I would like to put this code into VBA, I have managed to use it in a macro attached to a command button, and it works exactly as advertised. Thanks for your help.