This Userform serves as a data entry tool. inorder to ensure a good user experience, Several things were put in place. such things involve checking for user input, validating numeric, date, and text inputs. Additionally, the code was thoroughly commented to facilitate future modifications and to enhance code readability for others who may work with it. Here’s how the form works : 1) The user fills the form with data. in the course of filling the form, the following fields “Bill” , “Total Charges” and “Installment” accept only numeric input . For the “Installment Date” field, the form checks the validity of the entered date in real-time as the user types. If an invalid date is entered, the label “Installment Date” turns red to notify the user of the error 2) Upon clicking the “Add” button, the form runs a quick validation process before submitting the entry. It verifies that the “Installment Date” is a valid date and also checks if any of the fields were left blank. If there is an issue, a message box alerts the user accordingly. In the case of a blank field, the message box offers the option to submit with the field left blank or to return to fill it. The form prevents submission if any errors occur, but the previously entered details remain intact without being cleared so the user can fix error in the entered data and re-submit the form data. 3) Once the user addresses any error and clicks “Add” again, the form successfully submits the data and automatically clears the form for the next entry.

This is a VBA form-based calculator used to calculate Material Cost, Labor Cost and the Number of days to make a beam. The product name and diameter are selected from the available options in a drop-down menu. The user cannot manually input values for these two fields. The “Quantity” field only accepts numerical inputs. When the user fills the calculator with values and clicks “Calculate Cost” the form checks for any empty fields among the three fields that the user is expected to fill. If any empty field is found, it displays an alert message using a message box. However, if no empty field is found, it proceeds to calculate and display the result in the “Calculated Result” field. The “Calculated Result” field is formatted to enhance readability i. e a number in thousands or millions is formatted with commas to prevent errors when interpreting the numbers. For example, a user can easily mistake 5 zeros for 6 zeros and vice versa if the numbers were not formatted properly.