Variables to Comments

[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

 

[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.

 

[MAS]

DOH...

Chr (10)

Thats the bit I couldn't remember.. Thanks..

M.