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
@pravinvasudevan
5 жыл бұрын
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
@iqbalsoula
11 жыл бұрын
it was very useful code thank you very much
@michaelskirde-visuata5742
3 жыл бұрын
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
3 жыл бұрын
Not that I know of. But you can check out these links: kzitem.info/news/bejne/joJryIWqf5dzgoY kzitem.info/news/bejne/yIuHu2Z9g5FerKQ
@Nathan-jh4xs
4 жыл бұрын
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
4 жыл бұрын
Run a looping process in the column that contains the copied comment matter and delete.
@naveenkumar-cb1xs
6 жыл бұрын
thank u
@shanoobolavanna
3 жыл бұрын
is there any technics to copy that to any cell not an comment but an cell matter
@Exceltrainingvideos
3 жыл бұрын
This VBA tutorial will guide: kzitem.info/news/bejne/rY6pk2ljbpF0pqg You can also search this channel using the keyword 'copy' to find more than 40 videos on this topic of copy and paste.
@ColoradoCollegeTigers
4 жыл бұрын
Want to copy cell text and add/paste to comment box. how is this done
@Exceltrainingvideos
4 жыл бұрын
Range("A6").AddComment Range("A6").Value
@ahmed19imran
5 жыл бұрын
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
5 жыл бұрын
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
5 жыл бұрын
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
5 жыл бұрын
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
@ronsuarez22
8 жыл бұрын
Is there a way to link comments from the same worksheet?
@Exceltrainingvideos
8 жыл бұрын
+Aaron Suarez Can you please elaborate?
@ronsuarez22
8 жыл бұрын
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
Пікірлер: 22