vba comment box

[jzamilpa3]

is it possible to insert a comment box and copy and paste wording
into
it from 2 diffrent columns on another sheet. the thing is that i have
a countif in sheet3 columnB for the wording in columnA. the wording
in
columnA is looked for in sheet2 that will provide how many times is
found. also there is wording next to the colunm the countif is
looking
at and i need or wanted to insert a commentbox with the wording from
sheet2 into columnB of sheet3.

let me know if doesnt makes sense.
thnks,
jose

 

[Mike H]

I'm afaraid I can't quite follow all of the question but perhaps you can
build on this. It adds a comment to B1 on Sheet1 and adds the text from A1 in
Sheet2

Sheets("Sheet1").Range("B1").AddComment.Text _
Text:=Sheets("Sheet2").Range("A1").Value

Mike

 

[jzamilpa3]

is it possible to add several text or diffrent cells in one column to
the same comment. for example

sheet 1
a b

bl a
asd a
fsd a
fs a
f b
sd c
fs c

sheet2
a b

a comment box of all a's
b comment box of all b's and so on
c
d