In many offices and small businesses in Indonesia, Excel is not just a calculation tool. It has become a place to store inventory, record cash, manage customer data, and compile monthly reports. Practical, inexpensive, and already familiar. However, as the data grows, manual processes start to feel fragile: rows shift, formulas get overwritten, and a single typo can have widespread consequences.
This leads to a question that is increasingly being asked. If Excel is used for almost everything, why not make it behave like an application?
From Regular Tables to Mini Applications
The answer lies in VBA (Visual Basic for Applications), the built-in programming language of Excel. With VBA, a workbook can be equipped with a UserForm: an input window that has fields, a save button, an edit button, and a delete button. This pattern is known as CRUD, an acronym for Create, Read, Update, Delete, the four basic operations that form the backbone of almost all recording systems.
The difference is immediately noticeable. Instead of typing data randomly into any cell, users fill out a structured form. Data is entered into a neat single location, validations can be applied to ensure mandatory fields are not left empty, and the history of changes is easier to maintain. The previously passive spreadsheet transforms into a working tool that guides its users.
Why Many Teams Choose This Path
The context in Indonesia makes this approach sensible. The Ministry of Cooperatives and SMEs reports that around 25.5 million MSMEs have entered the digital ecosystem as of mid-2024, with a target of reaching 30 million by 2025. However, "digital" here often means selling online, not necessarily having a well-organized internal recording system. Many business operators still rely on makeshift bookkeeping that is prone to errors.
Several studies in academia and industry show that Excel VBA serves as an affordable bridge to this issue. There are research projects that have built prototypes of bookkeeping systems for MSMEs based on Excel VBA. Others have designed integrated cash recording systems, where data input directly feeds into reports. At the corporate level, VBA is used to compile management reports, reducing processes that previously took hours. The common thread is the same: reduce repetitive input, minimize the chances of miscalculations.
The Role of AI and Its Limitations
What has changed recently is the way code is written. In the past, writing VBA often meant trial and error alone until late at night. Now, AI assistants can help write macro frameworks, explain unfamiliar functions, or diagnose why a line is erroring out.
However, there are boundaries that need to be maintained. AI does not understand your business rules: how discounts are calculated, when stock is considered critical, or the invoice number format used by your office. Such logic still comes from humans. AI-generated code also needs to be reviewed and tested, as the person who uses the data daily is the one who understands the context best. AI accelerates, while humans ensure accuracy.
Conclusion
Excel will not replace large-scale systems, and that is not its purpose. For many operational teams and small businesses, what is needed is a tool that is sufficient: organized, controllable, and does not require expensive infrastructure. As long as data remains in spreadsheets, the ability to transform it into a simple application is a skill that continues to gain value.
Sources
- Ministry of Cooperatives and SMEs via ANTARA News – Kemenkop UKM: 25.5 million MSMEs have "gone digital" → antaranews.com
- Infomatek Journal, Universitas Pasundan – Efficient Digital Bookkeeping for MSMEs (Excel VBA Prototype Development Approach) → journal.unpas.ac.id
- Kompak: Scientific Journal of Accounting Computerization, STEKOM – Integrated Cash Recording Automation Based on Excel VBA for Process Efficiency → journal.stekom.ac.id
- Indonesian Society Journal (Jumas) – Implementation of VBA Macro in Microsoft Excel for Management Report Preparation at PT. Perkebunan Nusantara IV Regional I → abdimasjumas.cattleyadf.org