Variables to Comments
 

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

--
Message posted from http://www.ExcelForum.com

Variables to Comments
 

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.

Variables to Comments
 

DOH...

Chr (10)

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

M.


"Charles " wrote in message
...
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


Charles


---
Message posted from http://www.ExcelForum.com/