How do I break VBA code into two or more lines?
 

Using Excel 2003/Windows XP/VBA Editor 6.3.
I have some very long lines which don't fit in the VBA Editor window and to
make the code easier to read I want to break them into two or more lines.
I was told to type a space then and underscore but this doesn't work.
(I am not talking about breaking the lines in Message Boxes).

How do I break VBA code into two or more lines?
 

Of course it works.

If Day(Date) 10 _
And Hour(Time) 20 Then _
MsgBox "It is after the tenth " & _
"and it is evening"

HTH. Best wishes Harald

"Kasama" skrev i melding
...
Using Excel 2003/Windows XP/VBA Editor 6.3.
I have some very long lines which don't fit in the VBA Editor window and
to
make the code easier to read I want to break them into two or more lines.
I was told to type a space then and underscore but this doesn't work.
(I am not talking about breaking the lines in Message Boxes).

How do I break VBA code into two or more lines?
 

<I was told to type a space then and underscore

and then press ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kasama" wrote in message ...
| Using Excel 2003/Windows XP/VBA Editor 6.3.
| I have some very long lines which don't fit in the VBA Editor window and to
| make the code easier to read I want to break them into two or more lines.
| I was told to type a space then and underscore but this doesn't work.
| (I am not talking about breaking the lines in Message Boxes).

How do I break VBA code into two or more lines?
 

I think Kasama has probably tried to break inbetween words maybe?

only break after complete words, (as harolds example shows) for some
reason it gets confused otherwise!
Duncan


Harald Staff wrote:
Of course it works.

If Day(Date) 10 _
And Hour(Time) 20 Then _
MsgBox "It is after the tenth " & _
"and it is evening"

HTH. Best wishes Harald

"Kasama" skrev i melding
...
Using Excel 2003/Windows XP/VBA Editor 6.3.
I have some very long lines which don't fit in the VBA Editor window and
to
make the code easier to read I want to break them into two or more lines.
I was told to type a space then and underscore but this doesn't work.
(I am not talking about breaking the lines in Message Boxes).

How do I break VBA code into two or more lines?
 

Hi Kasama

Like this

Sub Mail_workbook_1()
ActiveWorkbook.SendMail ", _
"This is the Subject line"
End Sub


See the space between the , and the _



--
Regards Ron de Bruin
http://www.rondebruin.nl



"Kasama" wrote in message ...
Using Excel 2003/Windows XP/VBA Editor 6.3.
I have some very long lines which don't fit in the VBA Editor window and to
make the code easier to read I want to break them into two or more lines.
I was told to type a space then and underscore but this doesn't work.
(I am not talking about breaking the lines in Message Boxes).

How do I break VBA code into two or more lines?
 

"Niek Otten" skrev i melding
...
<I was told to type a space then and underscore

and then press ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Lol. That may be the problem, yes.
MVP! Really glad to hear that, Niek.

Best wishes Harald

How do I break VBA code into two or more lines?
 

Tks, but that wasn't it. After typing Space+Underscore+Enter I was getting
"Invalid Character" error messages for the underscore. So I tried copying and
pasting your code and Harald Staff's code into blank macros. This time VBE
accepted the underscores, and then broke the line when I typed ' _enter'. No
more error messages.
But then I noticed a strange thing: up till now VBE has automatically placed
a line of underscores between my Sub procedures -- if I typed 'Sub' on a new
line after
'End Sub' I a dividing line of underscores automatically appeared.
These have now disappeared from all existing macros!
So it seems to me as if 'underscore' was assigned to a dividing line, and
after pasting in your code, VBE has reassigned unserscore to 'line continues
on next'.

Thanks

Kasama

"Niek Otten" wrote:

<I was told to type a space then and underscore

and then press ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kasama" wrote in message ...
| Using Excel 2003/Windows XP/VBA Editor 6.3.
| I have some very long lines which don't fit in the VBA Editor window and to
| make the code easier to read I want to break them into two or more lines.
| I was told to type a space then and underscore but this doesn't work.
| (I am not talking about breaking the lines in Message Boxes).