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

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

RBS


"Edward" wrote in message
ps.com...
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

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.
--


Gary


"RB Smissaert" wrote in message
...
http://www.oaltd.co.uk/Indenter/Default.htm

RBS


"Edward" wrote in message
ps.com...
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

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" <GKeramidasATmsn.com wrote in message
...
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.
--


Gary


"RB Smissaert" wrote in message
...
http://www.oaltd.co.uk/Indenter/Default.htm

RBS


"Edward" wrote in message
ps.com...
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

thanks for the heads up.

--


Gary


"RB Smissaert" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
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.
--


Gary


"RB Smissaert" wrote in message
...
http://www.oaltd.co.uk/Indenter/Default.htm

RBS


"Edward" wrote in message
ps.com...
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:

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.

--


Gary


"RB Smissaert" wrote in message
...
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" <GKeramidasATmsn.com wrote in message
...
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.
--


Gary


"RB Smissaert" wrote in message
...
http://www.oaltd.co.uk/Indenter/Default.htm

RBS


"Edward" wrote in message
ps.com...
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