Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Comment

  Asked By: Molly    Date: Feb 27    Category: MS Office    Views: 597
  

I want to link the text in comment to a particular cell.

For example, in A1, I insert a comment but the text is linked to cell Z1,
instead of manual type in the comment in comment box.

Is it possible?

Do I make any sense or confuse the hell of everyone?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Jet Brown     Answered On: Feb 27

Yeah, It is possible. Use following code..

With Range("A1")
.AddComment Range("Z1").Text
End With

 
Didn't find what you were looking for? Find more on Comment Or get search suggestion and latest updates.




Tagged: