I'm finding some way to make Excel comment box auto-size when I add a lot of text into it.
Some tries with Google and I've got this from Ozgrid but it doesn't work on my Excel 2010. Please help me some idea to make it work! Thanks!
Sub robot_comment() ' robot_comment Macro ' Keyboard Shortcut: Ctrl+Shift+R Dim objComment As Comment Set objComment = ActiveCell.AddComment With objComment .Visible = False .Text Text:="robot" .Shape.TextFrame.AutoSize = True End With End Sub