It’s not exactly the same as Wordle but close enough 🙂
Continue readingWord Game in Excel
Posts Tagged → 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
Worksheet_Change Keep All Time Min Max Numbers
Excel is not meant to store historical data. That’s what databases do. However, Tom Urtis shows us a trick to keep the all time min value from a single input cell. 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
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
formula or vba to add spaces?
Add a space after each character in a cell. Excel expert Tom Urtis solved it with vba. I solved it using a formula. Let’s compare these methods. Continue reading
Video 00158 Keyword Data Validation List
Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review several solutions to this problem. Continue reading
Video 00171 Create Christmas Lights Using Excel Sheets
Did you know that an Excel UDF can change the color of a sheet tab? David Hager’s post shows us how to do this! Somehow I came up with the idea to create Christmas Lights using Excel sheet tabs! Continue reading