Read an inserted comment in an excel file from VBA

Michel Rapin 1 Reputation point
2021-10-17T17:35:29.883+00:00

Is it possible to read an inserted comment in an excel cell using a VBA macro?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,996 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-10-18T03:04:26.267+00:00

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

    0 comments
  2. Michel Rapin 1 Reputation point
    2021-10-18T15:13:51.517+00:00

    Thank you. It is exactly what i was looking