Comment Box Size

[JamesPW]

Can a comment box be configured with a set width and grow the height as required to fit the text *as I type* it? It could start as 100 characters wide x 1 line high but when I hit 101 characters it wraps to the next line and the comment box grows by a line vertically to show all the text.

Currently you can set the width and it will wrap at that width but if you're out of room vertically the text disappears below the comment box. You have to grab a handle and manually stretch the box to show all the text.

Thanks

 

[Michael M]

I don't believe a comment box can be dynamic like that.....but I'll be interested to see the code, if any !!

 

[My Aswer Is This]

Comment Box sizes can be modified using Vba.
Look at this link for more information:
https://www.contextures.com/xlcomments03.html#DateTime

 

[Michael M]

@MAIT
I agree...and Debras site gives a lot of options....BUT...The op has stated

"*as I type* it?

Which I'm still pretty sure VBA can't do ...

 

[My Aswer Is This]

@MAIT
I agree...and Debras site gives a lot of options....BUT...The op has stated
Which I'm still pretty sure VBA can't do ...

I agree.