@Michel Rapin
As this issue focus more on VBA code, I would add a related tag to help you better. Thanks for your understanding.
I find a link as following, hope it could be helpful.
"Get a List of All the Comments in a Worksheet in Excel".
(But please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.