I used Dick’s Generate Sample Data add-in to build a list of 50 people.
Start off with a blank workbook, and add a 3 column list of people: First Name, Last Name, City. I suppose it had to happen at some time, but eventually it all clicked and now I want to use this approach for every programming assignment I take on.įor this article, we’re going to create a collection of People, and write code dealing with those people. My ways consisted of modules of Functions, and managing “lists of things” using Arrays and User Defined Types. Years of programming in assembly language had wired my brain in a way incompatible with OO and every time I tried to use Classes and Collections, I quickly became frustrated and reverted back to my old ways. I had done plenty of reading on Object Oriented programming, but I just didn’t understand the attraction. When I first started programming in Excel VBA, I had problems using Class modules.
