VBA Code Formatter 1

[ajcarr]

I used to use an excellent add-in VBA code formatter but unfortunately, due to a major system crash (disc controller failure crunched both RAID 1 discs!), I have lost it. I have back-ups of all my application data but neglected to back-up the add-ins I used (DOH!)

I have searched all sorts of sites without success. It was a simple add-in to the edit menu in VBA. Can anyone point me towards it?

Thanks,

Allan

 

[xlbo]

Quick google search turned up this:

http://downloads.zdnet.co.uk/0,39025604,39055869s,00.htm

and

http://download.com.com/3000-2352-10157376.html

May be the same add-in but looks like what you describe

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[ajcarr]

Geoff, I found that one but it wasn't the one I was looking for. That one is a programm which formats the VBA as an input file. The one I had previously was an add-in which could be used dynamically while writing code.

 

[xlbo]

do you remember what it was called ??

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[ajcarr]

I'm afraid I can't remember the name - it was about 18 months ago that I installed it. I think it came from one of the MVP wbsites or something like that. It wasn't a company product from what I recall.

 

[xlbo]

Is this it ???

http://www.mztools.com/download.htm

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[ajcarr]

Geoff, an interesting looking package but that's still not it. It was an add-in to the Edit menu rather than the Tools Menu. Very simple - just click on the option to reformat current procedure/current module or project.

I'm still searching using all sorts of keywords. I was just hoping someone would recognose it!

 

[xlbo]

another 2 to try:

http://www.prettycode.com/

http://www.soft411.com/software/free/vb-source-formatter.html

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[xlbo]

Final stab in th dark - Stephen bullen's smart code indenter:

http://www.BMSLtd.ie

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[ajcarr]

Geoff, many thanks - that's the one. It is a very useful tool for keeping your code tidy, especially with many levels of indents when you lose track of 'end if's'.