Variables to Comments

C

Charles

Mas,

This is a sample of a recorded code.

Range("A2").Comment.Text Text:=" My Name:" & Chr(10) & "hghghg"
Chr(10) & "jkjkjk" & Chr(10) & "klklk"

HTH


Charle
 
M

MAS

Hi,

I have read this somewhere but can't bottomed such a simple issue...

Whilst getting VBA to write some variables into a new comment, how do I add
a carriage return so that each variable is entered in the comment on a new
line ?

Ta.
 
Top