cutting a code in 2 lines

[RJ1969]

Please Login or Register  to view this content.

How do I cut the codes in the second line. For example,

1st line
setFirstCell = UCase(InputBox("Please enter the first cell reference to fill


2nd line
e.g. Reference A2 or B2", "First Cell?", "A2"))

Thank you

[6StringJazzer]

To continue a line of code to another line, insert " _" at the end of the line. It can go anywhere a space or delimiter can go.

But you cannot split a line in the middle of a quoted string. You can split the two into two strings:

Please Login or Register  to view this content.

If you want the input box displayed to the user with a line break, you can insert a line break character without splitting the line:

Please Login or Register  to view this content.

[RJ1969]

ok.. Thank you.

[Rick Rothstein]

Please Login or Register  to view this content.

If you want, you can use the built-in Line Feed character constant vbLf in place of the Chr(10) that I highlighted in red above.