Software Design using Visual Basic for Application and Microsoft Excel Programming for Students

Abstract

The rapid development of information technology has made people to have the ability to design software with a programming language. There are quite some engineers who have not mastered programming languages. It happens becausesome people think that developing software with a certain programming language is very difficult. The language is difficult to understand, the accuracy must be precise, and the user is not familiar with the platform. Difficulty in learning programming languages is a problem that is often encountered by university students, vocational students, or employees. This article describes an easy programming language training activity for beginners, namelyVisual Basic for Applications (VBA)-Ms. Excel training.The advantage of this programming language iseasy to operate because manystudentsor employees are very familiar with Ms. Excel so that the adaptation process will be easy. The results of the post-test training that was attended bystudents showed a significant increase in the ability to design programming languages.

Desktop Application for Traceability System on The Printed Circuit Board (PCB) Storage Process

“…As demonstrated in [9], Visual Basic has been successfully utilized for stocktaking automation processes, incorporating Quick Response (QR) codes to enhance the effectiveness and efficiency of state property management. The benefits of using Visual Basic for application development include straightforward operation, seamless integration with Microsoft Excel, and efficient data processing, as highlighted in [10]. The initial step in designing this application involves creating the User Interface (UI), which consists of several integrated Windows forms.…”

Development of Excel-Based Building Defect Management System Using Business Process Reengineering in Education Building

“…For that reason, an Excel-based application system can be a system with a database that is a data recapitulation and, at the same time, a tool for issuing cost and time analysis that works well to manage maintenance and care, especially defect monitoring in buildings (Mustafa & Hatemi-J, 2022). Microsoft Excel features that can simplify big processing data include a drop-down menu, Value Look Up (VLOOKUP), and Conditional Formatting (Ramadhan et al, 2020). Previous research also shows that the Microsoft Excel function could effectively help users to solve maintenance processes by reducing the completion of maintenance reports from months to 5-10 days.…”