EXPORT COMMENTS from the ALL sheets of the WORKBOOK to another sheet

Recently I've received a question: How to export all comments from all sheets in one workbook to another new sheet. You will create a VBA code, which will help you:
1.Create a new sheet
2.Name this sheet as "Comments"
3.Name 3 columns as
-"Comment In" - for address of the Comment -Name of the sheet & cell address
-""Comment by" - the author of the comment-"Comment" - the text.
4. Put all these headers in Bold and specific color.
5.Extract Comments.
Finally you will see a trick - what will happen if the name of the author will be changed in the comment.
My Links:
🔴RUclips: / myexcellife
🔴Pinterest: www.pinterest.es/jekasama/
🔴Twitter: / jeka_sama
🔴Instagram: / my_excel_life
Thank You for Visiting my Channel ❤️
#MyExcelLife #ExcelTutorials #exceltips #excel @MyExcelLife

[@tharunkumararulselvam4537]

I am getting a syntax error with the formula. I believe it is because of the ":=" and an expression is expected. Any advice on how to solve this? Because from what I can tell my code matches the code you pasted

[@MyExcelLife]

Hi, I think it's because you missed something in the code. You can test it using F8 and Locals Window. If you don't know how to use it - you can take a loot to my video "How to DEBUG macro in Excel" ruclips.net/video/lU0ARlryVm8/видео.html

[@BeastStats]

How can I get this code?

[@MyExcelLife]

You can go through the video and find it there

[@SudeshSivenarain-sf8ph]

Hi there, the code does not seem to work, can you share these please.
My issue is on this part where there is a syntax error.
Anchor:=Worksheets("Comments").Range("A2").Offset(count,0),_
Address:="",_
Subaddress:=""'& Ws.Name&"'!"&cmt.Parent.Address,_
TextToDisplay:=""'& Ws.Name&"'!"&cmt.Parent.Address

[@MyExcelLife]

Hi, I think it's because use did not use Space between "Offset(count, 0)," and underline. Should be:
Anchor:=Worksheets("Comments").Range("A2").Offset(count, 0), _
Address:="", _
Anyway you can aslo test the code using F8 and Locals Window. If you don't know how to use it - you can take a loot to my video "How to DEBUG macro in Excel" ruclips.net/video/lU0ARlryVm8/видео.html