Hi,

I'm kind of a beginner in VBA and I'm struggling with a, for me, really complex problem.

I want to copy a comment from a cell in excel into a word dokument.

Here is more exactly what I want to do:

I have a word document with a lot of text and an excel document with comments attached to cells in a column.

Lets say that the excel document looks like this:

Column A: A1: Dog - comment "wof wof"
A2: Cat - comment "mjau"
A3: Horse - comment "iiha"
... and so on

the word dokument looks like this:

text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text text..

Dog

text text text text text text text text text text text text text text text text text text text..

Cat
.... and so on.

What I whant the macro to do is:
  • If the word Dog appears in the word document.
  • Find the cell that contains the text Dog in column A in excel.
  • Copy the comment "wof wof" attached to the cell whith Dog in it.
  • Paste the comment "wof wof" after the word Dog in excel.

Then do the same for Cat and Horse and so on.

Would be very thankful if anyone knows how to do this in VBA.