As posted previously, there are some truly great add-ins for the VBE (VBA Editor), one of which is the Smart Indenter. That said, with the various changes in OS and MS Office products there have been a few bumps in the road trying to get it to install properly with the latest and greatest versions. In a recent thread on UtterAccess, one member reported that they managed to get it properly installed and the solution was to actually install the IndenterVB6.exe rather than IndenterVBA.exe. Seems counter intuitive, but definitely worth trying out so you can continue to use this small, but powerful tool!
Update 2020-04-03 2016-02-25
Also, I was informed by fellow MVP Jack Stockton, that Smart Indenter will work with the MSI installer, but not with the Click-to-Install/Click-to-Run edition of MS Office. So if you buy the standalone MS Office then you should be able to install Smart Indenter, but if you are using MS Office through an Office365 account, then sadly you won’t be able to. This is yet one more issue with the Click-to-Install/Click-to-Run editions.
Fellow MVP Tom van Stiphout has now confirmed that the above is no longer true and that Smart Indenter is now compatible with all versions.
Thanks for the post. I’m using Win 10 and Access 2016 and have been googling myself crazy looking for information about how to get Smart Indenter to work. I would like to try the solution you suggest–installing IndenterVB6.exe,–but it’s no longer available for download from oaltd.co.uk. I get an error message that the download link points to a file location that can’t be found. Would you happen to know of another source for this file?
I’m afraid I do not have another source for downloading.
Hi there, this link is working : http://www.oaltd.co.uk/DLCount/DLCount.asp?file=IndenterVB6.exe
https://www.experts-exchange.com/articles/26599/Installing-Smart-Indenter-in-Office-2013-2016.html
Unfortunately, it looks like that Smart Indenter 3.5 is a thing of the past. I could not make that work, no matter what. However, it has been rewritten and is now supported via open source with many new features and is working very nicely on my Access 2016. Indentation is done with programmable hotkeys, either for a module or procedure (Ctrl – M and/or Ctrl – P).
It is an app in the works but it solved the immediate indentation problem. Download at:
http://rubberduckvba.com/
Feedback your experiences here.
I am aware of rubberduck. It is an interesting add-in.
The beauty of an add-in like Smart Indenter is it did one “simple” thing very well! unlike many others which you install for one such feature but end up with 100 others that you just don’t need. More isn’t always better.
I was surprised to see that the original author released the code, because I had asked a while back to make it public domain (MVPs were going to help) and they refused. It is a great gain for the community that RubberDuck managed to change his mind.
Daniel,
I am running an O365 account. I can install SmartIndenter using IndenterVBA.exe. The issue I’m having is with MZTools3VBA setup. It still installs, saves my options and has the functionality I use, BUT when I close Access I get a MZTools caused a violation. When I restart Access -SmartIndenter is there and operational, but MZTools is gone.
Yes, I, and others, experience the same issue. I believe an MVP tried to address this with the developer but no solution was found. Your only true solution is to purchase Mz-Tools V8 or simply reactivate Mz-Tools V3 every time you need it.
08-01-2019 Rancho Cucamonga CA
Hi Folks …
There is a simple solution to installing Smart Indenter, including on Window 10 / O365 (Access) Click To Run.
https://www.experts-exchange.com/articles/26599/Installing-Smart-Indenter-in-Office-2013-2016.html
I used Solution # 1.
First … go this this folder:
C:\Program Files (x86)\Common Files\DESIGNER
Rename the more current version of MSADDNDR.DLL (mine is 07-07-2015) to something like _MSADDNDR.DLL
Then I got the version of this file from my Win 7 / Office 2010 machine … a version from 06-18-1998 (!!) and put it in the folder above.
Then I double clicked on IndenterVBA.exe … it installed with no issue and is fully functional within the Access VBA IDE.
I was also able to install VBETools_v2.0.exe … another oldie but goodie 🙂
Haven’t tired MZTools 3.0 yet, BUT … I’m just going to install MZTools V8 …. time to make the switch.
Joe Anderson … (former) Access MVP.