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

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
As per my knowledge there is no any word wrapper available but you can use "_" and convert one line code to multi line.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,563
Messages
6,114,332
Members
448,566
Latest member
Nickdozaj

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
Back
Top