Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same code, different line
How do you continue the same line of code on a new line?
Basically instead of having one long line where you would need to scroll horizontally to see the end, you can have it spread over a number of lines and only scroll vertically. Thanks for your speedy response. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same code, different line
Hello Neil,
Code line can be devided by _. (a space and underbar) eg. Code: -------------------- MyVariable = _ "A" & _ "B" & _ "C" -------------------- --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same code, different line
"Neil" wrote in message
... How do you continue the same line of code on a new line? Basically instead of having one long line where you would need to scroll horizontally to see the end, you can have it spread over a number of lines and only scroll vertically. Thanks for your speedy response. It's done using undersco ActiveWindow.Selection.SlideRange.Shapes _ .AddShape(msoShapeRectangle, 246, _ 288, 138, 132).Select |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same code, different line
Neil,
Your character is the underscore. Be aware, it must be at the end of the line, must be after a space and you there is a limit to the number of "line continuations" you're allowed. Sub testit() Dim strMyValue As String strMyValue = _ "How do you continue the same line of code on a new line? " & vbNewLine & _ "Basically instead of having one long line where you would" & vbNewLine & _ "need to scroll horizontally to see the end, you can have" & vbNewLine & _ "it spread over a number of lines and only scroll" & _ "vertically." MsgBox strMyValue End Sub "Neil" wrote in message ... How do you continue the same line of code on a new line? Basically instead of having one long line where you would need to scroll horizontally to see the end, you can have it spread over a number of lines and only scroll vertically. Thanks for your speedy response. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
modify a line code | Excel Discussion (Misc queries) | |||
code line with two conditions | Excel Discussion (Misc queries) | |||
line code modification | Excel Discussion (Misc queries) | |||
What's wrong with this line of code? | Excel Programming |