Hello My Friends, and welcome to another #SolutionsSaturday”. This week’s question comes to us from Paul Allu who asks “As a software developer why did you choose VBA instead of another programming language”
Thanks so much for the great question and I am happy to answer that. There are a few reasons actually.
The reason I got into VBA was primarily because I was familiar with and loved working with Excel since 1996. Although it was not until 2008 when I discovered VBA, I realized that VBA could not only automate so many of the things I was doing manually, but also do things that could not be done with traditional Excel Formulas & Functions. So the first reason was simply that I was very familiar working with Excel, it was just a natural progression to move to VBA.
The 2nd reason was that Excel was already on millions and millions of machines around the world, so I knew that if I developed applications within Excel it would be easily adapted by users who would not have to install any additional software. I really loved the idea of ‘plug and play’ and users could simply open up their Excel application, activate macros if needed, and start to use the application. With no installation required and no setup or directory changes, many customers were already familiar with the application and its features so the learning curve was a lot less then creating a brand new application. This sped up the time to market.
Lastly, with Excel & VBA, I could easily customize existing applications to fit customers exact requirements. This type of agile software development really allowed me to create some amazing and customizable software for individual customers in a very short amount of time. This type of flexibility is one of Excel’s and VBA strengths when developing software for both specific customers and products that are available on the market.
If you would like to increase your Excel skills there is no better way to do that than with the Advanced Excel Dashboard Masterclass. Join tons of happy students who are now creating amazing applications right here: http://bit.ly/309qh3n
You can get 100 of my BEST Excel workbooks in one zip file for just $37.00 right here today: http://bit.ly/309r0BD
IF you are looking to enhance your Excel learning, there is no better application to have then the ULTIMATE Excel Resource Guide. With 1000 Resources including 100 PDF downloads, 100 Free Excel Courses, 100 Excel Websites and blogs, this is by far the best Excel Resource you will ever own. See all of the amazing benefits right here: http://bit.ly/3084zN7
Thanks so much for the great question Paul. I hope you have enjoyed this Solutions Saturday.