Editor word wrap

gnowak

New Member
Joined
Mar 12, 2009
Messages
13
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

Well-known Member
Joined
Apr 11, 2009
Messages
574
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can put your code on multiple lines using a space followed by and underscore. Example:

Code:
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

New Member
Joined
Mar 12, 2009
Messages
13
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.
 

Forum statistics

Threads
1,082,480
Messages
5,365,798
Members
400,854
Latest member
zenith_11

Some videos you may like

This Week's Hot Topics

Top