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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,531
Latest member
WalterR01

This Week's Hot Topics

Top