ExcelBanter - Trying to set comment to Cell value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Trying to set comment to Cell value (https://www.excelbanter.com/excel-programming/320930-trying-set-comment-cell-value.html)

Jeff

Trying to set comment to Cell value

I want to set the comment to the value of a cell. However when I try to do
this I keep getting an error.

I've tried
ActiveCell.AddComment.ShtRef.Value and
ActiveCell.AddComment.Range("A1").Value and
ActiveCell.AddComment.Cells(R1 - 68, CurMth)
Any ideas

Norman Jones

Trying to set comment to Cell value

Hi Jeff,

Try:

ActiveCell.Comment.Text ActiveCell.Value

---
Regards,
Norman

"Jeff" wrote in message
...
I want to set the comment to the value of a cell. However when I try to do
this I keep getting an error.

I've tried
ActiveCell.AddComment.ShtRef.Value and
ActiveCell.AddComment.Range("A1").Value and
ActiveCell.AddComment.Cells(R1 - 68, CurMth)
Any ideas

Norman Jones

Trying to set comment to Cell value

Hi Jeff,

Or, to insert a comment ans set the comment text to thw cells value, try:

With ActiveCell
.AddComment Text:=.Value
End With

---
Regards,
Norman

"Jeff" wrote in message
...
I want to set the comment to the value of a cell. However when I try to do
this I keep getting an error.

I've tried
ActiveCell.AddComment.ShtRef.Value and
ActiveCell.AddComment.Range("A1").Value and
ActiveCell.AddComment.Cells(R1 - 68, CurMth)
Any ideas

All times are GMT +1. The time now is 09:23 PM.