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

Fadillah Ramadhan, Hendang Setyo Rukmi, Arif Imran, Cahyadi Nugraha, Risdan Ferdiansyah


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.


Ms. Excel; programming; software; training; VBA


Astuti, P. D. (2011). Sistem informasi penjualan obat pada Apotek Jati Farma Arjosari. Speed - Sentra Penelitian Engineering Dan Edukasi, 3(4), 34–39.

Cazzola, W., & Olivares, M. (2016). Gradually learning programming supported by a growable programming language. Emerging Topics in Computing, 4(3).

Fisher, M. (1996). Integrating information technology: Competency recommendations by teachers for teacher training. Journal of Information Technology for Teacher Education, 5(3), 233–238.

Hyde, K. M., & Maier, H. R. (2006). Distance-based and stochastic uncertainty analysis for multi-criteria decision analysis in Excel using Visual Basic for Application. Environmental Modelling & Software, 21(12), 1695–1710.

Irmawati, D., & Indrihapsari, Y. (2014). Sistem informasi kearsipan untuk meningkatkan kualitas pelayanan. Jurnal Pendidikan Teknologi Dan Kejuruan, 22(2).

Li, X., Zhang, C., Almeev, R. R., & Holtz, F. (2020). GeoBalanc: An Excel VBA program for mass balance calculation in geosciences. Geochemistry, 80(2).

Liu, H., Wei, S., Ke, W., Wei, K. K., & Hua, Z. (2016). The configuration between supply chain integration and information technology competency: A resource orchestration perspective. Journal of Operation Management, 44, 13–29.

Nakic, Z., Posavec, K., & Bacani, A. (2007). A visual basic spreadsheet macro for geochemical background analysis. Groundwater, 45(5).

Nasikin, K. (2011). Pengembangan sistem informasi akademis dan keuangan di MAN 2 Pati. Journal Speed, 3(3), 20–26.

Perez-Lopez, S., & Alegre, J. (2012). Information technology competency, knowledge processes and firm performance. Industrial Management & Data Systems, 112(4), 644–662.

Sa’ari, J. R., Luan, W. S., & Samsilah, R. (2005). Attitudes and perceived information technology competency among teachers. Malaysian Online Journal of Instructional Technology, 2(3), 70–77.

Saputra, R. (2015). Desain sistem informasi order photo pada creative studio photo dengan menggunakan bahasa Visual Basic .NET 2010. Jurnal Momentum, 17(2), 86–93.

Sophan, S. (2014). Pengimplementasian dan perancangan sistem informasi penjualan dan pengendalian stok barang pada Toko Swastika Servis (SS) Bangunan dengan menggunakan bahasa Visual Basic 6.0 didukung dengan database MySQL. Jurnal Momentum, 16(2), 34–44.

Valipour, M., & Montazar, A. A. (2012). Optimize of all effective infiltration parameters in furrow irrigation using Visual Basic and genetic algorithm programming. Australian Journal of Basic and Applied Sciences, 6(6), 132–137.

Wong, K. W. W., & Barford, P. (2010). Teaching Excel VBA as a problem solving tool for chemical engineering core courses. Education for Chemical Engineers, 5(4).



  • There are currently no refbacks.

Published by :

Department of Electrical Engineering Institut Teknologi Nasional Bandung

Address : 20th Builiding Jl. PHH. Mustofa 23 Bandung 40124

Contact : Phone 7272215 (ext. 206) Fax 7202892

Email :




Flag Counter

Visitor Statistics

This journal is licensed by Creative Commons Attribution-ShareAlike 4.0 International License.

Creative Commons License