Copy Comments Automatically using Excel VBA

[@pravinvasudevan]

thank you for your video about how to import multiple cell comments to another cell at one click. it was quite helpful. cud u please also share video of how to make vlookup and get the comment(having picture in it) on to another cell. the same comment(with respecive image) will appear on the another cell as vlookup result. thanks

[@Quoit1]

Hello , I am a big fan of your tutorials and use it all the time. I have a question regarding your pervious videos - I have an excel file that I use to copy data from one workbook to another by clicking on 'submit' button. I want is, when the button is pressed it should ask the user to locate which excel file to update. Thanks a lot

[@iqbalsoula]

it was very useful code thank you very much

[@michaelskirde-visuata5742]

Nice tutorial! Do you have a VBA Code to do the other way around? Copy cell Content for several cells into a comment? Thx

[@Exceltrainingvideos]

Not that I know of. But you can check out these links:
ruclips.net/video/-L5bQtFeBOQ/видео.html
ruclips.net/video/gUQU2GJ_-yo/видео.html

[@Nathan-jh4xs]

This is awesome Dinesh, thankyou... HOWEVER! once i delete the comment, the text remains in the cell it copied to, is there a way to automatically delete the copied text if the comment gets deleted????

[@Exceltrainingvideos]

Run a looping process in the column that contains the copied comment matter and delete.

[@shanoobolavanna]

is there any technics to copy that to any cell not an comment but an cell matter

[@Exceltrainingvideos]

This VBA tutorial will guide: ruclips.net/video/LXs-5-5_Css/видео.html
You can also search this channel using the keyword 'copy' to find more than 40 videos on this topic of copy and paste.

[@ColoradoCollegeTigers]

Want to copy cell text and add/paste to comment box. how is this done

[@Exceltrainingvideos]

Range("A6").AddComment Range("A6").Value

[@ahmed19imran]

Hi Sir, can we do it reversably I mean copy cell value and make it a comment. Please answer my query thanks in advance!

[@Exceltrainingvideos]

Sub CellDataToComment()
Dim myRng As Range
Dim Rng As Range
On Error Resume Next
Set myRng = Range("A2:A9")
For Each Rng In myRng
Rng.NoteText Text:=Rng.Value
Next
End Sub
Your data in Ranges A2 to A9.

[@Exceltrainingvideos]

Sub CellDataToComment()
Dim myRng As Range
Dim Rng As Range
On Error Resume Next
Set myRng = Range("A2:A9")
For Each Rng In myRng
Rng.NoteText Text:=Rng.Value
Next
End Sub
Your data in Ranges A2 to A9.

[@Exceltrainingvideos]

Sub CellDataToComment()
Dim myRng As Range
Dim Rng As Range
On Error Resume Next
Set myRng = Range("A2:A9")
For Each Rng In myRng
Rng.NoteText ""
Next
End Sub

[@naveenkumar-cb1xs]

thank u

[@ronsuarez22]

Is there a way to link comments from the same worksheet?

[@Exceltrainingvideos]

+Aaron Suarez Can you please elaborate?

[@ronsuarez22]

I have a identical table between 2 sheets in the same workbook, currently I am working at sheet 1 and added a comment, what i want is whenever I add/change a comment from sheet 1, it will also be added/change into sheet 2