安裝中文字典英文字典辭典工具!
安裝中文字典英文字典辭典工具!
|
- excel - How to continue the code on the next line in VBA . . .
In VBA (and VB NET) the line terminator (carriage return) is used to signal the end of a statement To break long statements into several lines, you need to Use the line-continuation character, which is an underscore (_), at the point at which you want the line to break
- VBA line continuation and its limit - Excel at Finance
Another way to break lines for improved readability, and also overcome the 24 line-continuation limit is to use concatenation and build the string in a number of steps To illustrate this, the Nested24 procedure is extended to a Nested64 procedure
- Too many line continuations | Microsoft Learn
Make some of the constituent lines physically longer to reduce the number of line-continuation characters needed, or break the construct into more than one statement For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh)
- Line Break in Code - Introduction to VBA
You can improve the readability of your code by breaking it in the middle using space + underscore to continue the code on the next line This article explains how to break code in VBA and provides practical examples
- vba - Excel macros - Too many line continuations - Stack Overflow
Make some of the constituent lines physically longer to reduce the number of line-continuation characters needed, or break the construct into more than one statement " -- MSDN There's only one way -- to use less continuations This can be done by putting more text on a line or by using concatenation expressed differently: query = " "
- VBA Editor. . Long line Line too long | MrExcel Message Board
Okay, the answer is: you can't break a line of VBA code inside a string If you want to break a line inside a string you have to terminate the first portion with ", insert the underscore, then commence the next line with an ampersand and a new opening quote for the second portion of the string
|
|
|