I decided to add more some more functionality to my Application Settings addin. In fact, I also changed the name to Excel Settings. (It's actually a different file, so please be sure to click "Ch...
http://andrewexcel.blogspot.com/2017/10/application-settings-is-now-excel.html
I made a new version of my Application Settings addin as per Sébastien's comments in my last post (mirrored on the Daily Dose of Excel ). As you can see, there are new settings for the foll...
http://andrewexcel.blogspot.com/2017/09/application-setting-addin-version-2.html
Back in 2005, I noticed something that worried me. You may know already that switching Application.Calculation to xlCalculationManual can make various code run faster. It can be a big time save...
http://andrewexcel.blogspot.com/2017/08/application-settings-addin.html
At a former client, I was asked to submit monthly reports that show details of work performed in 15 minute increments. My line of thought went something like this, "Let's see, a monthly calend...
http://andrewexcel.blogspot.com/2017/05/monthly-report-tutorial.html
Yet another tool has been added! You can now run a report that shows project statistics. It's a good way to get a general feel of how much work you have done, and where it is located. Details...
http://andrewexcel.blogspot.com/2017/04/aet-vbe-tools-v173.html
Already? Didn't you just release v1.7.1? Yes, and I'm pleased to announce 2 new additions to the tools! FIND CODE IN PROJECT This tool creates a report that works in a similar way to the buil...
http://andrewexcel.blogspot.com/2017/04/aet-vbe-tools-v172.html
It has been a busy couple of weeks, but I added some new features to my VBE tools. LINE CONTINUATION Here's a pic of what's available. My version of line continuation adds spaces and undersco...
http://andrewexcel.blogspot.com/2017/03/aet-vbe-tools-171.html
Finally they're ready! What's new? 1. RENAME USERFORM CONTROLS This tool allows you to batch rename all controls on a userform via a simple Find and Replace interface. In addition to changing...
http://andrewexcel.blogspot.com/2017/03/aet-vbe-tools-v17.html
Latest patch - 2 bugs have been fixed, and one change has been made to certain wording. Fixed an indentation bug when the first procedure of a module was at the very top (No Option Explicit and...
http://andrewexcel.blogspot.com/2017/03/aet-vbe-tools-v164-and-overall-progress.html
This patch concerns another change to the Undo code, and is in case you unchecked "Trust access to the VBA project object model" after launching Excel. Perhaps unlikely, but I like to avoid poten...
http://andrewexcel.blogspot.com/2017/02/aet-vbe-tools-v163.html
Just a quick post to let you know the a new patch has been uploaded. Indentation had a bug fixed when there were comments immediately after "Then" in If... Then code. Cleanup Project Code had...
http://andrewexcel.blogspot.com/2017/02/aet-vbe-tools-v162.html
Yes, it's still freeware. Think of it as a patch. I'm still committed to updating this version by fixing any bugs that I find, or tweaking this and that with improvements. It won't have as many...
http://andrewexcel.blogspot.com/2017/02/aet-vbe-tools-v161.html
This will be the final freeware version. Let's see what we have so far. Access AET VBE Tools by right clicking within the active code pane. Here are the tools. INDENT CODE Indent code wi...
http://andrewexcel.blogspot.com/2017/02/aet-vbe-tools-v16.html
Jordan Goldmeier is an expert at creating dashboards in Excel and is releasing a training course to help you master them too. I've had a look at the course myself and have this to say. I a...
http://andrewexcel.blogspot.com/2017/01/excel-dashboard-pro-course.html
So soon? Yep, I made a couple of small improvements under the hood. Better now than later. Download the new version here .
http://andrewexcel.blogspot.com/2017/01/aet-vbe-tools-v15.html
Another week, another tool. COPY CODE You can now "copy" code between projects. By this I mean the following, Standard modules, class modules and userforms will be be replaced if they ex...
http://andrewexcel.blogspot.com/2017/01/aet-vbe-tools-v14.html
I've been working on the latest version of AET VBE Tools all weekend, literally. It's been an all out effort, so I made some major improvements to the code, and added a little more functionalit...
http://andrewexcel.blogspot.com/2017/01/aet-vbe-tools-v13.html
AET VBE Tools v1.2 is out. More bugs were squashed and a new tool called Multiple Find and Replace was added. The download link is here . I'll add more details later. Time for sleep.
http://andrewexcel.blogspot.com/2017/01/aet-vbe-tools-v12.html
Last time I blogged, I mentioned that my new AET VBE Tools had more stuff coming. Well, I've been VERY busy adding new tools and settings, redesigning and also fixing bugs, both major and mino...
http://andrewexcel.blogspot.com/2017/01/aet-vbe-tools-v11-and-line-numbers.html
T'was the night before Christmas, when all thro' the house, not a creature was stirring, except for an eccentric developer, who can't rhyme to save his life. But he can code a bit. So this i...
I'll be honest. I never use icon sets. But I had a look at them the other day and thought that they didn't do what I expected. Here's a screenshot of them in action. For those not familiar...
http://andrewexcel.blogspot.com/2016/12/icon-set-alternative.html
When you want to add a calendar to a userform, you can try to make use of the Microsoft Date and Time Picker Control. Unfortunately this control is not 100% reliable and a number of people have d...
http://andrewexcel.blogspot.com/2016/07/calendar-date-picker-control-alternative.html
I decided to add an extra feature to my Find and Replace tool. When using the Find and Select mode, I thought it might be useful to have an option where you don't just select cells containing t...
http://andrewexcel.blogspot.com/2016/05/aet-find-and-replace-v13.html
I'm working on various updates. One thing I have done is make yet another change to my AET Data Checker . I changed it so that when you show the form, the sheet you have on your screen (the Activ...
I've added some new stuff to my AET Data Checker addin. First, I added some labels so you can see what the Main Column and Look At Column are referring to (not just the Column letter) The ...
http://andrewexcel.blogspot.com/2015/08/aet-data-checker-new-features.html