How to Auto Size Comment Box To Fit Its Content in Excel

How to auto-resize comment box to fit its contents in excel?
In this advanced excel tutorial, I'll show you how you can automatically resize comment box to match its content in excel. If you don't auto fit comments box, you'll have to scroll inside the comment to see its content. That is indeed a tedious job. If you follow this tutorial, you'll never have to manually auto-resize comment box again. In this tutorial, I'll use the VBA code, and that code will automatically resize comment boxes in excel.

Learn All About Comments In Excel: bit.ly/excelcomments

To auto-size comment box in excel, please follow the instructions below

Step 1: Hit the Developer tab. Check this link: youtu.be/jkSLYLk0OHU to Add Developer Tab in Excel.
Step 2: Go to Visual Basic (VBA Programming Course: bit.ly/excelvbacourse)
Step 3: Click on "Insert" & "Module."
Step 4: Write your code (Please subscribe and here goes the code: patreon.com/posts/36388086)
Step 5: Hit on the "Run" Button
Step 6: A popup will open, and you'll need to add the Data range here.
Step 7: Select the data range and done.
The macro I used will auto-size comment box to fit its content.

#Autosize #Comments
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
patreon.com/excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ

Here goes the most recent video of the channel:
bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelcomments
Excel VBA Programming Course: bit.ly/excelvbacourse

Social media:
Facebook: facebook.com/excel10tutorial
Twitter: twitter.com/excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: excel10tutorial.tumblr.com
Instagram: instagram.com/excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
Quora: bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
youtube.com/@Excel10tutorial/join