Excel VBA - How to set a comment on a cell with VBA?

[behedwin]

How can i populate a cell with a comment using VBA code?

And then how to make the text in the comment hold a cell´s value like A1
And how to make a new line in a cell comment?

 

[mikerickson]

Range("B1").NoteText "Hi. I'm a comment"
Range("B2").NoteText "When this code was exicuted, the value in A1 was " & Range("A1").Text

Range("B3").NoteText "Comments do not contain dynamic contents" & vbCr & "Auto updating the comment in B2 would require VBA"

Or you could use the MacroRecorder to find a different syntax for adding a comment.

 

[behedwin]

Range("B1").NoteText "Hi. I'm a comment"
Range("B2").NoteText "When this code was exicuted, the value in A1 was " & Range("A1").Text

Range("B3").NoteText "Comments do not contain dynamic contents" & vbCr & "Auto updating the comment in B2 would require VBA"

Or you could use the MacroRecorder to find a different syntax for adding a comment.

Ok i got it to work now.
But as you said the content is not dynamic.
I first loaded with your text... then changed to my text.... and now still yours text are still in the comment.... How to get it to update the data?

Adding this line gives me an empty box of a comment

Range("G4").NoteText Range("G4").Text & "random text: " & Range("h4").Text & "random text " & vbCr & "random text" & Range("i4").Text & " random text" & vbCr & Range("g4").Text & " random text " & Range("j4").Text & " random text " & vbCr & "kljölkj lökjölkj " & Range("k4").Text & " jlaösjfdslkfjsdlök " & vbCr & "text text tdslfaj " & Range("l4").Text

 

[mikerickson]

I first loaded with your text... then changed to my text.... and now still yours text are still in the comment.... How to get it to update the data?

I can't replicate that behavior.

 

[behedwin]

I solved this by giving up the idea of using "comment".
Created a label instead that i hide/unhide on click on a cell instead.
It was a bit more "code"... but it works as i want still.

Found quite allot of different approaches to handle comment/notes in excel.
I never got any of them to work well... even tho i think made some kind of mistakes on the road