How To Change A Comment Box Shape And Format

How To Change A Comment Box Shape And Format

The default comment box in Excel is pretty plain, but you can change the shape, colours, fonts and borders among others things to make them stand out.     Enter the comment format editing mode by clicking on the comment and you will see small squares around...
How To Get All Comments In A Workbook With VBA

How To Get All Comments In A Workbook With VBA

Comments can be a great way to add a small bit of documentation to your spreadsheets. If your spreadsheet gets too big and with many sheets then important comments can easily get lost somewhere in the workbook and forgotten about. Here we’ll show you an easy way...