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.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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,133,429
Messages
5,658,740
Members
418,467
Latest member
sc356448

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top