Long Formula's displayed in VB on Screen

[Guest]

Easy One....but how do you break up a formula in VB so that you can see it on
the screen without having to scroll right?

 

[David F Cox]

use _
to _
join _
lines

 

[Guest]

I assume you mean something like this?

TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg

use _
to _
join _
lines

 

[James]

Yes but you need a space at the end between your code and the _

James

I assume you mean something like this?

TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]

 

[Guest]

Works well!!!

Thanks
--
Heiko K Stugg

Yes but you need a space at the end between your code and the _

James

I assume you mean something like this?

TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg

use _
to _
join _
lines

Easy One....but how do you break up a formula in VB so that you can see it
on
the screen without having to scroll right?

 

[Terry Kreft]

Note there is a limit (24) to the number of line continuation characters you
can use in one statement.

--

Terry Kreft

Works well!!!

Thanks
--
Heiko K Stugg

Yes but you need a space at the end between your code and the _

James

I assume you mean something like this?

TotWt = [WPF01] + [WPF02] + [WPF03] + [WPF04] + [WPF05] + [WPF06] + [WPF07]
+ [WPF08] + [WPF09] + join_
[WPF10] [WPF11] + [WPF12] + [WPF13] + [WPF14] + [WPF15] + [WPF16] +
[WPF17] + [WPF18] + [WPF19] + [WPF20] + join_
[WPF21] [WPF22] + [WPF23] + [WPF24]
--
Heiko K Stugg


:

use _
to _
join _
lines

Easy One....but how do you break up a formula in VB so that you can see it
on
the screen without having to scroll right?