Here’s the VBA code to fix the height and width of the comment box in Excel: Sub ResizeALLcomments () Dim c As Object For Each c In ActiveSheet.Comments c.Shape.Width = <width> c.Shape.Height ...

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...