Showing related tags and posts accross the entire site.
-
If you have ever used the Treeview control from the “Additional controls” section, then you know what a versatile control this is to show hierarchically organized data. There are a couple of problems with this Treeview control: Compile errors due to a difference in how the control libraries...
-
To put your cursor in the Immediate Window, press Control+G. We all know that. To get it back to the code pane, I use Control+R, then Enter. Control+R puts the focus on the Project Explorer pane with the last active module highlighted. Enter just “opens” that module. A few months ago, I learned...
-
For years I’ve been typing <code> tags and pasting code between them. But no more! I wrote a small utility that puts the code tags around my code and pops into the clipboard. Think of the seconds that I’ll save.
There are three situations that I wanted to cover with this code; no ...
-
Dick Kusleika shared VBE Find, a solution that intentionally had no choices and a straightforward UI. [In his post he also pointed out a few limitations with it.] Unfortunately for him, I liked it so much that I enhanced it to the point that he might now be uncomfortable with the bells and [...]
-
In Adding Functionality - 2a I laid out the UI changes to support sorting of the results of Dick Kusleika’s VBE Find.
In this post, I develop the actual sort routine.
To recap, the task is to sort a 2D matrix on any number of columns. The sort columns are listed in a 1D array, with [...]
-
Dick Kusleika’s VBE Find is useful enough that it justifies the resources need to enhance it.
In addition to adding Regular Expression searching (Adding functionality - I) a sort capability made sense since since the results include code from multiple code modules and procedures within them. The...
-
I’ve mentioned MZ-Tools on this blog many times. It’s a great set of utilities for the VBE. You also probably know about Smart Indenter. I don’t use that one myself, but many people do. Ken Puls commented that neither of those work in 64 bit Excel. I’m some ways away [...]
-
Rob’s post made me revisit some class module code, so it’s probably going to be class module week. Stop groaning out there.
First, a quick discussion on the merits of property statements vs. public variables. Rob comments:
I don’t see the point of traditional public property get/set if only...