Turn off auto-alignment option in VBA Editior

[Colin Steadman]

Just a quick question, does anyone know if there is an option in the
standard office VBA editior to stop it from auto-aligning my code?

For example if I type this:

sql = "blah"
sql_ad2 = "blah2"

Then the editor helpfully aligns it like this when I move the cursor
away:

sql1 = "blah"
sql_ad2 = "blah2"

TIA,

Colin

 

[Perry]

Nope.

From what I know, there are (at least) a couple of exceptions:

Declarations like indicated below, allow you to use yr own alignment
in the code grid

Const MyString As String = "asdf"
and
Dim MyStr As String

Type MyString
AnyString As String
End Type

Public WithEvents app As Word.Application

Even toggling the CompileOnDemand in VBA options, won't allow you
to use yr own code alignment.

Krgrds,
Perry

 

[Colin Steadman]

Nope.

From what I know, there are (at least) a couple of exceptions:

Declarations like indicated below, allow you to use yr own alignment
in the code grid

Const MyString As String = "asdf"
and
Dim MyStr As String

Type MyString
AnyString As String
End Type

Public WithEvents app As Word.Application

Even toggling the CompileOnDemand in VBA options, won't allow you
to use yr own code alignment.

Krgrds,
Perry

OK nevermind! Thank you.