VBA is therefore different from the Standalone Visual Basic program used(by professional programmers) for developing commercial quality software applications _ though it borrows many of the latter's features. Think of Excel VBA as being the standalone Visual Basic software, built into Excel for the benefit of Excel users who are not necessarily programmers, but who are keen to exert more control over the application. So, Excel VB offers any interested users the necessary tools to make the application deliver more functionality. The final product is still an Excel document, but with extra functionalities added using VBA.
I am keen to encourage individuals and organisations to explore using advanced MS Excel formulas and functions, in conjunction with Excel VBA programming, to develop customised spreadsheet applications that will solve typical problems end_users encounter daily in trying to record/analyse data and generate reports.
In my article titled You Can Increase Your Profits Without Changing Your Prices, I ended with the following summary: If You Remember Nothing Else, Remember The Following: 1. One good way to maintain and/or significantly increase your profits without raising your prices, is to reduce your Variable Costs(VCs). 2. You can reduce your variable costs by marketing more efficiently (getting more customers at lesser cost, AND maintaining them at lower expense). I once read an article that proposed a new parameter COCS: Cost Of Customers Sold or Served). This could be adopted as a Key Performance Indicator(KPI). 3. You can also reduce your variable costs by innovating more(i.e. developing greater efficiency in your routine internal operations and/or product/service delivery). That way, you would be able to produce/deliver more products and/or services with less effort, in less time, and using less resources. All of these would imply LOWER expenses/costs, leading to INCREASED profit retention per unit of product/service sold. 4. There is saying that: "You cannot manage something, if you do not measure it. Nor can you measure it, if you do not record it". Spreadsheet tracking will help you conveniently implement and sustain the process of monitoring, controlling and/or reducing your VCs. You will need to do this so as to constantly evaluate progress of your VC monitoring/control and reduction initiatives.
So, (when considering the automation I speak about) do not think about spreadsheet documents containing one or two click_able buttons that allow a user print a page or copy some cells from one sheet to another. Instead, I want you to picture an application(or Entreprise Information System) that customises the appearance of your spreadsheet workspace(to take advantage of maximum screen capital available on your PC), and offers you custom "floating" data entry forms.