Alternative IDE for VB6 and VBA

vba vb6 ide vbe
Omar Kooheji picture Omar Kooheji · Oct 22, 2008 · Viewed 53.4k times · Source

I've been spoiled by Visual studio 2008 and Eclipse and have to do a little maintainence work on a VB6 app.

Does anyone know of an alternative/ updated IDE for VB6?

A rewrite is not an option I'm just fixing a couple of bugs and it's a big codebase.

Answer

Shane Miskin picture Shane Miskin · Oct 23, 2008

I have never heard of an alternative IDE for Vb6. However, these two (free) VB6 add-ins are indispensable and will make your life easier - especially if there is a lot of code. They are equally effective for VBA in Microsoft Office.

MZ-Tools: provides a superb collection of IDE tools - finding unused variables, unused methods, a great "search all", code snippets. Written by Carlos J. Quintero, to whom I now owe hours and hours of time.

http://www.mztools.com/v3/mztools3.aspx

And SmartIndenter, which takes care of all the auto-indenting. It does one thing and it does it well.

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

Screencap of MZ-Tools Menu

Related questions

Does VBA have Dictionary Structure?

Does VBA have dictionary structure? Like key<>value array?

Read More
VBA array sort function?

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work with MS Project 2003, so should …

Read More
What is the difference between dim and set in vba

Pardon me as am a newbie in VBA. Sometimes I use Dim r as Range r = Range("A1") Other times I use Set r = Range("A1") What is the difference? And when should I use what?

Read More