put info from cell into comment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Not sure how to use this UDF.....I need the information that is in other
cells to be put into a comment box.
Shaun


Try this UDF:

Function copycomment(r As Range)
Application.Volatile
Dim whereami As Range
Set whereami = Application.Caller
If whereami.Comment Is Nothing Then
Else
whereami.Comment.Delete
End If
whereami.AddComment Text:=r.Value
copycomment = ""
End Function


I need to link information found in other sheets of my workbook to comment
 
Just paste your UDF into a regular module and in the cell where you want the
comment box, type =Copycomment(Sheet2!B1) and it will put the value in cell
B1 of sheet2 in the comment box where you typed that formula

hth
Vaya con Dios,
Chuck, CABGx3
 
Shaun

Stick with one thread.

You have an answer at your original posting in this NG


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UDF to copy formatting as well as text? 1
Macro to insert pictures in comments 8
UDF in module of personal.xls 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Center All Pictures in Excel Cells 1
For Gord or other: dynamic comment 7
Linking Comment to Cell 4
Input Box 2

Back
Top