Excel VBA Projects 

I developed a multi-step Excel VBA data entry application utilizing UserForms and MultiPage controls to create a guided workflow for customer information capture. The system dynamically writes validated form data to Excel using efficient VBA logic, ensuring structured data storage, improved accuracy, and consistent data entry. 

I designed and developed a customized Booking Tracking Data Entry Form using Microsoft Excel and VBA to streamline and automate my client’s homestay reservation management process. The system provides a professional and user-friendly interface that allows staff to efficiently capture guest information, booking details, room selection, and pricing in a structured format. It features an integrated date picker for check-in and check-out, with automated calculation of the number of nights and total booking cost to ensure accuracy and eliminate manual errors. The automated submission function securely records all entries into a centralized Excel database, improving data organization, operational efficiency, and overall workflow reliability. This solution significantly reduced manual processing time, enhanced data accuracy, and provided a scalable and professional booking management tool tailored to the client’s business needs.

I designed and developed an Excel VBA UserForm–based attendance entry system for the Meet & Greet Session with Pocket Talk: Coffee Making organized by HRD Corp Sabah. The system enables efficient participant registration by capturing attendee details through a structured UserForm and automatically storing records in Excel. This project improved data accuracy, streamlined on-site registration, and reduced manual attendance tracking during the event.

I designed and developed an Excel VBA UserForm application with search and record navigation functionality to improve data accessibility and usability. This project allows users to search for specific records and navigate between entries using first, previous, next, and last controls, enhancing efficiency and reducing manual interaction with Excel sheets. 

I designed and developed an Excel VBA UserForm application that enables users to add, update, delete, and save records within a structured dataset. Through this project, I implemented CRUD operations, automated data entry processes, and improved usability by using UserForms to minimize direct interaction with worksheets.