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

K

Kasama

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).
 
H

Harald Staff

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
 
N

Niek Otten

<I was told to type a space then and underscore >

and then press ENTER

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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).
 
D

Duncan

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
 
R

Ron de Bruin

Hi Kasama

Like this

Sub Mail_workbook_1()
ActiveWorkbook.SendMail "(e-mail address removed)", _
"This is the Subject line"
End Sub


See the space between the , and the _
 
H

Harald Staff

Niek Otten said:
<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
 
K

Kasama

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top