Filter
Exclude
Time range
-
Near
I use a vba userforms in excel to create presentations.
4
2,656
This month came with one mission: build more solutions, solve more problems, and push @msexcel past its limits. So before Oblee begins let’s build systems ! It started as a simple idea: “What if I could track income and expenses without manually typing every single thing?”
Next thing I knew, I was knee-deep in VBA modules, user forms, and macros… and suddenly the project turned into something bigger. Something smarter. Something I’d actually want to use every day. What I’m Building: A Fully Automated Income & Expense Tracker (VBA-Enabled) A system that feels less like a spreadsheet…
and more like an app living inside Excel. Automated Entries Created Add Income and Add Expense buttons that open clean user forms—
just click, fill, and the tables auto-populate with zero errors. No scrolling.
No dragging formulas.
Just click → enter → done. Smart Currency Selector One of my favourite parts:
A pop-up form that displays currencies from 8 countries. Traveling?
Relocated?
Living digital nomad life? No problem.
Pick your currency → all entries update accordingly.
(Let’s just say the module behind this one took a little “midnight debugging love.” 😅) Visual Tracking (Work-in-Progress) I’m experimenting with a simple visual panel that updates as you enter data.
Income vs Expense
Totals
Balance
Your financial story, but simplified. Think of it as a dashboard that grows with you. Under the Hood (For My Excel People) •UserForms for clean data entry •VBA modules controlling responsiveness •Automated table insertions •Macro-enabled buttons •Error handling for smooth use •Goal: a highly responsive workbook that behaves like an App Still building, still testing, still refining… but the vision is clear. For Small Businesses & Creators If you still track sales, expenses, or income using spreadsheets, but want something smart, automated, and custom to your workflow 
let’s build it. Custom Excel or Google Sheets solutions.
No stress, no complexity. 
Just clean automation that saves your time and gives you clarity. 📩 Hit me up. Let’s bring your ideas to life. #Excel #VBA #Marcoenable #ExcelBoss
2
5
45
828
7 Jul 2025
Replying to @elonmusk
But can it create a .xlsm file with code and UserForms built in?
19
How to Build UserForms - Transform Excel with VBA Read our Free Step-By-Step Blog tutorial which has a downloadable practice workbook and video. Click the link below 👇👇👇 myexcelonline.com/blog/userf…
2
206
4 Mar 2025
"This tutorial will demonstrate how to use the VBA UserForm Show method. We'll also explain how to call macros and show other userforms from an existing userform." wellsr.com/vba/2018/excel/vb…
1
19
📊Interactive Column Chart for Excel UserForms ◾️It's a class module ◾️I reverse engineered a worksheet column chart to enable anyone to automatically generate column charts on a UserForm with a single line of code. Available on: punditexcel.com/
1
2
615
born to create more silly userforms in excel, forced to fix other people excel issues
4
44
25 Jan 2024
"This tutorial will demonstrate how to use the VBA UserForm Show method. We'll also explain how to call macros and show other userforms from an existing userform." wellsr.com/vba/2018/excel/vb…
2
86