How To Get All Comments In A Workbook With Vba

  First create a new sheet called “Comments” for the purpose of writing out all the comments. Then add this bit of code into the visual basic editor.    

  Now all you have to do is run the code and all your comments will appear in the sheet you created called “Comments” and you will be able to click the hyperlink to go to the cell containing the comment.