auto-indent in vb editor

[Edward]

Is there a way to auto-indent code in the VB editor for macros in
Excel? That is, if my code looks like:

if a = 7 then
call b
end if

change it to:

if a = 7 then
call b
end if

Thanks.

Edward

 

[RB Smissaert]

http://www.oaltd.co.uk/Indenter/Default.htm

RBS

 

[Gary Keramidas]

installed this and found a problem. it seems to delete shortcut keys assigned to
a macro. i have control-shift-r assigned to a code module that print previews a
report.

after running indent project, or opening the module and running indent
procedure, the shortcut is deleted. go to the options for the macro and it's
blank.

just thought i'd pass it on. sent the author an email, too.

it does do a good job, though.

 

[RB Smissaert]

There is one more, much more serious problem.
If you run the indenter and there is a syntax error in your
code then the indenter code can go in an endless loop, freezing it up.
There is no other way out of this then to kill Excel with Ctrl + Alt + Del.
This means losing all your work if you are working on an .xla project
and possibly also if you were working on an .xls file.
So, best always to run Debug, Compile before running the indenter.
Not sure if this serious bug has been fixed in the latest version, but I
sure
have wasted several hours work due to this.

RBS

 

[Gary Keramidas]

thanks for the heads up.

--


Gary

There is one more, much more serious problem.
If you run the indenter and there is a syntax error in your
code then the indenter code can go in an endless loop, freezing it up.
There is no other way out of this then to kill Excel with Ctrl + Alt + Del.
This means losing all your work if you are working on an .xla project
and possibly also if you were working on an .xls file.
So, best always to run Debug, Compile before running the indenter.
Not sure if this serious bug has been fixed in the latest version, but I sure
have wasted several hours work due to this.

RBS

 

[Gary Keramidas]

rb:

you know what gets me sometimes?

when i am testing some code, using a userform with a command button the print
previews something. i always forget to make the userform modeless or unload it
before the page preview. the only i have been able to break the loop is to end
the task and lose all of the work.