| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
| in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
| SUM IF and two variables | Excel Worksheet Functions | |||
| How to see all variables? | Excel Programming | |||
Linear Mode
