With VBA you can flexibly write just the code you need for your program. It is a flexible, functional programming language that is also aware of the Excel Object Model. You can easily access and manipulate almost all of the Excel objects: Worksheets, Cells, Charts, Tables, Shapes, Printing settings and much more.
However, there are objects and tasks that are not readily...
In a project I delivered this week to a new customer in Australia, it hit me that I have combined dashboards with updating data records for long time. Intuitively, as I envision the customer’s line of thought, I usually allow the user to cross the lines and open an update screen straight from a dashboard.
In the traditional data-centric approach to business information...
The idea for this Blog post came as I was forwarded a similar question on Quora to answer. I’ll offer my perspective for the discussion on this question.
Before we explore the business motivation and possible strategies for protecting your work, let’s recap all of the protection options we have in Excel:
You might be surprised this question is even raised. Intuitively, once you’re an “Excel VBA Developer”, then you’re an “Excel VBA Developer”. Right?! Well, let’s look closer.
Consider Joe. Joe is an accountant in a large corporation. He is an avid Excel user, really stretching the grid and built-in functions. Joe started recording some Macros to automate some tasks....
When starting a business, and even during its first years, many seem to pay little attention to their Information Systems (or software solutions). Why? Because it’s one of those things that doesn’t stop the show, and isn’t really taught in business schools as a strategic enough lever. There are much more pressing issues...
Most of you are probably already familiar with the recent addition to my Excel mastery offerings: The Ultimate Excel Date Picker. If you’re not, now is the time to pause and have a look: https://morsagmon.com/datepicker.
Unlike a customer-specific project, the Date Picker is a standard product. What’s the difference, you’re asking? A project is designed to meet specific needs of a particular...
As I was updating myself with Excel questions in Quora this morning, considering what to post in my Quora Excel VBA Expert Space, I came across this question: What is the most useful Excel function that no one ever uses? I needed less than a second to shout out: SUMPRODUCT!
The...
Ever received an error message popping up from an application you had no idea what it means, what to do and what’s going to happen to your data you just entered? Maybe something like this:
How does it make you feel? Do you know what caused this error? Do you know how to avoid it next time? Do you...
Couple of weeks ago, I was approached by a business owner, with this story: he’s offering an online service that matches home loaners with investors. For every mortgage need, he matches many small investors (any person, basically) to fund this loan. Loaners’ monthly receivables are distributed to the loan’s funders, short of the...
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!