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 "Check settings when opening/saving files" on the menu if you want these to fire). What's new? As you can see, I added 2 new sections for Workbook Scope and Worksheet Scope settings. The picture pretty well speaks for itself. And, if your file is saved (has a path), you can see File Size, Last Saved (Date and Time) and Last Edit (Author) details. The download link is here ..read more

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 following. Application.Iteration Application.MaxIterations Application.MaxChange In the case of the last 2 settings, you'll notice that there are Set, Reset and Save buttons. This is how they work, Set: Set to the number that is entered in the text box. Reset: Reset to the real default or “alias” default. Save: Save an “alias” default instead of Excel’s real default. For example, if you prefer 120 inste ..read more

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 saver. The problem, as I see it, is not switching it back to xlCalculationAutomatic. Given that some people for whatever reasons might use Manual Calculation all the time, most people don't, especially the vast majority of average users who probably haven't heard of this setting. With Calculation still set to Manual, they might be looking at values that haven't be updated. Even experienced programmers migh ..read more

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 calendar, something like the one on my fridge door comes to mind and making one in Excel should be easy..." One problem is space. If I do several tasks in one day, do I use tiny font to make the details fit, or do I make the calendar larger to the point that I have to scroll copiously? Also, just how practical is that style of calendar going to be when it comes to adding up total time per task? Something ..read more

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 include: Module Names Procedure Names Count of Children (Project and Modules) Procedure Scope Count of Lines (Project, Modules and Procedures) Count of Comments (Project, Modules and Procedures) Count of Declaration Lines (Project and Modules) Count of Declaration Comments (Project and Modules) Download the new version here. P.S. If you have purchased an earlier version, contact me by email and I'l ..read more

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 built-in Find dialog in the Visual Basic Editor. Details include, Module Name Procedure Name Instances (count of code found) Select Current Procedure Do you hate scrolling? Selecting all code in a module is easy, just use the Ctrl + A keys on your keyboard. A procedure - not so easy, especially if it's a loooong procedure. Trust me, this tool helps. You and your hand(s?) can thank me later. Downlo ..read more

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 underscores after And and Or keywords. So something like If Left$(LTrim$(.Lines(lCodeLine, 1)), 4) = "Sub " Or Left$(LTrim$(.Lines(lCodeLine, 1)), 12) = "Private Sub " Or Left$(LTrim$(.Lines(lCodeLine, 1)), 11) = "Public Sub " Or Left$(LTrim$(.Lines(lCodeLine, 1)), 9) = "Function " Or Left$(LTrim$(.Lines(lCodeLine, 1)), 17) = "Private Function " Or Left$(LTrim$(.Lines(lCodeLine, 1)), 16) = "Public Function ..read more

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 the control names, it also changes code with the old control name to the new control name. So, if you want to change all controls that start with "CommandButton" to "btn" or "cb", etc, this is the way to do it all at the same time! 2. Make Project Variables List The bigger the project, the more complex it becomes. This tool analyses your code and makes a list of variables and constants. Details ..read more

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 no Declarations). Also fixed a bug with Macro Comment Tools when more than one tool was used with the form still open. And I changed the wording of some messages to simplify translations for international versions! 2 translations are being prepared - Portuguese and Japanese - and I want your help to translate into other languages! Please contact me the email address below. Other Progress It's b ..read more

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 potential bugs whenever possible. v1.6.3 is available here. Also, thanks to everybody who ticks the G+1 icon at the bottom of my posts. It gives me incentive to keep doing my best ..read more