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 ...

Last month’s article, “ Pro tip: Add a UserForm to aid data entry in Excel,” shares the basics of creating an Excel UserForm using VBA to populate list controls. To update the list, you can ...