Editor word wrap

[gnowak]

Hi.

Is it possible to enable a word wrapper in Microsoft Excel 2007 VBA-editor(You get one line displayed on multiple lines if the line is wider than your screen)?

The same functionality as in the Visual Studio Editor : Edit -> advanced -> Word Wrap (shortcut key ctrl + w).

Thanks.

 

[somnath_it2006]

As per my knowledge there is no any word wrapper available but you can use "_" and convert one line code to multi line.

 

[Andrew Poulsom]

You can put your code on multiple lines using a space followed by and underscore. Example:

Sub Test()
    MsgBox "First part." _
        & " Second part."
End Sub

If you are breaking in the middle of a string you must close the quotes and begin the next line with an ampersand and opening quotes.

 

[gnowak]

Thanks.

The solution with "_" is widely used, but it does not support screens with different widths.

In other words I am trying to move away from that solution.

It is very sad if word wrapping does not exist in the VBA-editor.