Browse by Tags

An MSForms Treeview 2: Ready for beta testing

Hi everyone, Some time ago I announced I was working on “An MSForms Treeview” replacing the Common Controls Treeview with an all-VBA counterpart. This home-made treeview control will work on any Office version as of Office 2000, including 32 and 64 bit Office. I expect it will even work on MAC Office, but I’m still [...] Read More...

Published Fri, Feb 02 2013 10:20 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Downloads, User Interface, ActiveX Controls, UI Design, Excel Advanced

An MSForms Treeview

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 are registered in 32 bits Windows’ System32 [...] Read More...

Published Thu, Jan 01 2013 4:24 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, Collections, VBA, MVP, Events, Visual Basic Editor, Windows API, Userforms and Controls, ActiveX Controls, Controls, UI Design, Excel Advanced

Retrieving Lost Comments

I’ve restored a few posts in the last few months that were lost. I didn’t restore any of the comments. Honestly, I should have but I didn’t even think about it. But when I went to restore the In Cell Charting post, I noticed there were 85 comments. That seemed worth my while. First I [...] Read More...

Published Mon, Nov 11 2012 8:30 AM by Daily Dose of Excel

Filed under: Classes, Arrays

Cloning Class Instances

I’m working on a project that requires me to make multiple copies of a custom object. That generally means I make a Duplicate method and assign each property of the source instance to the copy instance. It’s not terrible, but I just have to be careful that when I change the properties of the class [...] Read More...

Published Tue, Oct 10 2012 3:18 PM by Daily Dose of Excel

Filed under: Classes

Sorting a Custom Collection Class

I’ve been following Dick’s VBHelpers Build series (1, 2, 3) and his last post reminded me that, from time to time, I need to sort a collection of items in-memory. I don’t have to sort all that often, so my approach has changed over time. I’ve kind of settled on the following. Let’s say I have a [...] Read More...

Published Mon, Oct 10 2011 2:50 AM by Daily Dose of Excel

Filed under: General, Classes, VBA Advanced, Collections, VBA, Downloads, VBA Code Library, Modules

VBHelpers Build 3

In this iteration, I Create a generator for a FillFromRange method of the parent class Get rid of those unisightly blank lines when converting Public variables to Property statements Change FindBy to ChildBy (thanks Steve J) If I have a range of records that I want to put in a class, which happens a lot, I wanted to create [...] Read More...

Published Mon, Oct 10 2011 8:52 PM by Daily Dose of Excel

Filed under: Classes

In a class module, why use an unrestricted property?

Over the years, I have followed the “best practice” of always using a property get and let/set combination rather than just declaring a public variable. But, over the last few months I’ve started questioning this dictum. Now, before people start jumping up and down, I am aware of the many very, very good reasons why [...] Read More...

Published Sun, Oct 10 2011 10:42 PM by Daily Dose of Excel

Filed under: Classes, VBA, CodeCritic

More Class Module Automation

How was that video? Pretty super-awesome, huh? You can download VBHelpers.zip It’s rough, to say the least, but if you want to mess around with it, have at it. Here’s some more information on what was happening in that video: 0:00 First I insert a class module. Inserting modules is one of those activities that [...] Read More...

Published Tue, Oct 10 2011 8:57 PM by Daily Dose of Excel

Filed under: Classes

Automating Class Creation

Happy Spreadsheet Day. This year, it’s something about helping students. I don’t care about students. They don’t have any money and they spend all their time on the Facebook and the Twitter. Instead of helping students, I made a video about how I create custom class modules. If you use class module [...] Read More...

Published Mon, Oct 10 2011 8:40 PM by Daily Dose of Excel

Filed under: Classes

CFB Stats Refactor

I had some redundant code in my previous post that I’m going to fix up. First, this Public Function IsAway(hRow As HTMLTableRow) As Boolean Dim bReturn As Boolean bReturn = Left$(hRow.Cells(1).innerText, 1) = "@" [...] Read More...

Published Sun, Oct 10 2011 12:01 PM by Daily Dose of Excel

Filed under: Classes

CFB Stats Part II

In College Football Statistics, I created my Team and Game objects, filled the Teams collection, and wrote a FindByName property for Teams. Now the fun part; filling the Game objects. This is a long one and I’m not going to sit here and tell you it doesn’t need some refactoring. But it [...] Read More...

Published Sat, Oct 10 2011 11:05 AM by Daily Dose of Excel

Filed under: Classes

College Football Statistics

Who wants to talk about college football, class modules and XMLHttp requests? Anyone? Well, for the two of you left, here’s what I got. The problem with comparing team statistics, especially early in the season, is cupcakes. Cupcakes are teams that aren’t very good at football. Teams like to schedule [...] Read More...

Published Fri, Oct 10 2011 9:33 PM by Daily Dose of Excel

Filed under: Classes

Extend an object’s attributes to coordinate multiple userform controls

This was motivated by a question in the mrexcel.com forum. The person asking for help had multiple comboboxes in a userform, each of which contained the same items, A through L for the purpose of this exercise. These items were sorted alphabetically. He wanted that when the user selected an item in [...] Read More...

Published Mon, Apr 04 2011 4:02 PM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, User Interface

Another Disconnected Recordset Example

I had to do some pretty extensive filtering recently and employed disconnected recordsets to speed up the code, which it did. Except that I ran into a bug, or so I thought. When I made the ADODB.Recordset variable a private module level variable in the class, I got a run time error. [...] Read More...

Published Tue, Apr 04 2011 9:27 AM by Daily Dose of Excel

Filed under: Classes, Collections

NACHA Files Bonus

Just when you thought the class module fun was over, it’s not. As long as I have all this class infrastructure, I can leverage that into making some reports. As you are no doubt aware, employees get pissed off when you make errors on their paychecks. Therefore, a review report prior to [...] Read More...

Published Fri, Feb 02 2011 6:30 AM by Daily Dose of Excel

Filed under: Classes

Syndication

Recent Posts

Tags

News

Archives

An MSForms Treeview 2: Ready for beta testing

An MSForms Treeview

Retrieving Lost Comments

Cloning Class Instances

Sorting a Custom Collection Class

VBHelpers Build 3

In a class module, why use an unrestricted property?

More Class Module Automation

Automating Class Creation

CFB Stats Refactor

CFB Stats Part II

College Football Statistics

Extend an object’s attributes to coordinate multiple userform controls

Another Disconnected Recordset Example

NACHA Files Bonus