Add Comments to Data from Another Worksheet Column

How to add comments to data from another worksheet column automatically using VBA.

When we add a comment to a worksheet cell or range, it displays a red triangle at the right top corner. When we hover over the cell with the mouse, the comment is displayed. We can now view, for example, the designation of an employee or the price of an item which is located in a far away worksheet cell. Watch the video below:

Here is the complete VBA code:

Option Explicit

Sub AddCommentFromAnotherColumn()
Dim counter As Long
Dim lastrow As Long

lastrow = Application.WorksheetFunction.CountA(Range(“A:A”))

‘MsgBox lastrow

For counter = 2 To lastrow
Cells(counter, 1).ClearComments


For counter = 2 To lastrow
Range(“A” & counter).AddComment
Range(“A” & counter).Comment.Text Text:=Range(“Y” & counter).Value


End Sub

Comments in Excel

Further Reading:

Insert comments and notes in Excel

Published by

Dinesh Kumar Takyar

Welcome to! My aim is to help you learn MS Excel including VBA. I always felt that a good way to learn something was to find solutions to problems in that domain. That is why I share these Excel videos with you. Mostly these are questions asked during my corporate training sessions. I've been training individuals and companies in computers since 1991. I did my B. Sc. (Vordiplom), M. Sc. (Diplom) and Ph.D. (Dr. rer. nat.) from Hamburg, Germany. The best thing about solving some of my visitor's questions is that I also gain new insights. For more Excel VBA solutions you may like to visit my YouTube channel: For a structured Excel VBA training course online you can visit:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.