Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Comment continue the code on the next line in VBA

ayi

I would like to type the mathematical forumla in VBA code which many lines. I would like to split it into many lines. How do I do it?
For example:
<pre><code class="lang-auto">U_matrix(i, j, n + 1) = k * b_xyt(xi, yi, tn) / (4 * hx * hy) * U_matrix(i + 1, j + 1, n) + (k * (a_xyt(xi, yi, tn) / hx ^ 2 + d_xyt(xi, yi, tn) / (2 * hx)))

</code></pre>
is very long. would like to split it.
Tried this:
<pre><code class="lang-auto">U_matrix(i, j, n + 1) = k * b_xyt(xi, yi, tn) / (4 * hx * hy) * U_matrix(i + 1, j + 1, n)
_+ (k * (a_xyt(xi, yi, tn) / hx ^ 2 + d_xyt(xi, yi, tn) / (2 * hx)))

</code></pre>
But not working.. Need some guidance on this..

ayi_2

To have newline in code you use <code>_</code>
Example:
<pre><code class="lang-auto">Dim a As Integer
a = 500 _

80 _
90

MsgBox a

</code></pre>