My Spreadsheet Lab » Macros VBA
167 FOLLOWERS
My Spreadsheet Lab is about everything Microsoft Excel. Explore our posts in the category Visual Basics of Application (VBA). Enjoy as we mess around with Excel to formulate 3D Objects, Games, and a hosst of interesting stuff on an Excel spreadsheet.
My Spreadsheet Lab » Macros VBA
1y ago
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 ..read more
My Spreadsheet Lab » Macros VBA
1y ago
How can you improve your VBA skills? Even if it’s ridiculous. I needed to practice and ended up creating a robot and a bunch of random style hearts ..read more
My Spreadsheet Lab » Macros VBA
1y ago
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 ..read more
My Spreadsheet Lab » Macros VBA
1y ago
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 ..read more
My Spreadsheet Lab » Macros VBA
1y ago
Jordan Goldmeier’s rollover technique runs a VBA User Defined Function when you hover the mouse over a hyperlink formula ..read more
My Spreadsheet Lab » Macros VBA
1y ago
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells ..read more