It’s not exactly the same as Wordle but close enough 🙂
Continue readingWord Game in Excel
Post Category → Macros (vba)
3D Objects
I heard about 3D Objects from MrExcel. I’ve had fun combing a 3D model with VBA (it moves inside your spreadsheet!)
Continue readingwhack-a-merged-cell
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! Continue reading
UDF Rollover Jordan Goldmeier
Jordan Goldmeier’s rollover technique runs a VBA User Defined Function when you hover the mouse over a hyperlink formula. Let’s take a closer look! Continue reading
Excel Beer Game
I got this crazy idea for a game while drinking a Space Invader IPA from www.amsterdambeer.com It was a great way to learn more VBA!
Continue readingLearn VBA UDF
These days dynamic arrays, power query and DAX seem to be all the rage. But let’s not forget about an old friend: VBA UDFs (User Defined Function). Continue reading
All Combinations Using Power Query
Given 3 separate lists of text how can we create all combinations? I’ve known Power Query (Get & Transform) can create a cartesian product but it’s only now that it’s part of my active skill set. Continue reading
Valentine’s Day in Microsoft Excel
How can you improve your VBA skills? Build something! Anything! Even if it’s ridiculous. I needed to practice and ended up creating a robot and a bunch of random style hearts! 🙂 Continue reading
Video 00151 Custom Formats, VBA, and Nerds!
I doubt that you have ever seen custom formats presented like this before! Selecting a name from a drop down list changes the custom format and also displays a nerd! Continue reading
Video 00147 Conditionally Add Checkboxes using VBA
I often use check-boxes in my Excel videos to explain the solution steps. Creating them can be tedious so I thought that there had to be an easier way. Continue reading