*** NEW COURSE LAUNCHED: 105 Excel VBA Functions Explained - Click Here ***

The Full Dev to QA to Prod Cycle with Excel VBA Projects

When developing, delivering and maintaining software solutions, you need to manage the Dev-QA-Prod cycle. This is no different when developing an Excel based application * Here’s how I do it

The Basics of Development Lifecycle

After you finish developing a scoped application, you need to pass it over to QA – Quality Assurance. The QA folks are abusing the software and document their exceptional findings: logical errors, software errors, user experience issues, environment conflicts, and the like. Often, issues classified as important will bounce back to development for fixing....

Continue Reading...

105 Excel VBA Functions Explained: My New Course Launched Today

What makes this course unique * What is this course about * What did it take to produce this course * Is this course right for you?

Not that I planned to launch this new course when everybody is glued to the computer screen waiting for the Corona scare to pass by, but today is the day, and it’s out!

Those of you who follow me for a while, already know the wide portfolio of services and products I offer, all about developing business software with Excel VBA and leading many others to become such consultants.

IF you’ve completed my flagship course: Computer Programming with Excel...

Continue Reading...

Excel VBA: Late Binding or Early Binding?

When using external function libraries in VBA, you need to choose between late biding and early biding * What is it, why chose one over the other and how is it done properly?

When the offered VBA functionality is not enough

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...

Continue Reading...

Career Options for Excel VBA Developers

What can you do as an Excel developer? Can you make a living out of it? Is it worth anything in the job market? Here’s my take…

What Kind of an Excel VBA Developer are You?

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....

Continue Reading...

From a Developer’s Workshop: Developing the Ultimate Excel Date Picker

Making an attractive Excel product that runs on every Windows computer is challenging * What were my main considerations, tricks and compromises? Read on…

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.

Product vs Project

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...

Continue Reading...

Error Handling in Excel VBA: What, Why and How

Would you embark an airplane without safety doors, slides and oxygen masks? I won’t * While not a matter of life and death, I won’t deliver an Excel application without proper Error Handling. Here’s why, and a hands-on video on how to do it right

What is error handling?

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...

Continue Reading...

What Does it Take to Become a Successful Business Software Consultant?

Becoming a successful figure in any field required a combination of skills, resources, knowledge and experience. Why is one lawyer so successful while others are not? How about marketing consultants? * What is the recipe for a successful business software consultant?

The last two Blog posts clarified some questions about choosing VBA as the programming language for your business software consultant career. I presume by now you have come to appreciate the opportunity, and the alignment of your career goals with VBA. Frankly, you can take the Excel VBA courses I offer and find your way. This...

Continue Reading...

VBA As a Programming Language: Pros and Cons

Should you consider investing in learning Microsoft’s Visual Basic for Applications? It is so ubiquitous as it is supported by all MS-Office installations. However, it was not adopted as a general, all purpose programming language by the professional developers’ community. Who would benefit and what are the pros and cons of learning and becoming a professional VBA developer?

In my last blog post I offered a brief analysis of why VBA was not adopted by the professional developers’ community as an all-purpose business applications technology. You will not find too many...

Continue Reading...

Why isn’t VBA Popular Amongst Software Programmers?

A glimpse at any major open positions board will quickly reveal VBA is not among the popular programming languages out there, when it comes to business applications. This is surprising, considering the fact it is the language used in MS-Access, a database-oriented applications development environment that is part of the MS-Office 365 Business Suite, and the underlying language of the other, most popular MS-Office Suite of applications.

Brief VBA History

Ever since it was introduced in 1993 with Excel 5.0, VBA hesitantly played in between two fields: Microsoft’s Office applications...

Continue Reading...
Close

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!