excel vba userform

Project Title: Data Literacy Online Live Course (DS360 x BSMRSTUCC) Registration Form

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

About Dataset & Files

Dataset Source: Data Solution - 360

Introductory Key Points:

This is an Excel VBA (Visual Basic Application) project where a registration form is created in Microsoft Excel using the VBA codes & interfaces.
This Registration Form is created for the student registration in the live online free course, titled "Data Literacy - 1107", jointly organized by Data Solution - 360 and Bangabandhu Sheikh Mujibur Rahman Science and Technology University (BSMRSTU) Career Club.
Students from BSMRSTU are supposed to participate in this online live course, so this registration form is created for the students of BSMRSTU only.
The project file contains 2 excel sheets (1 empty sheet titled "Empty_Sheet" & 1 invisible record sheet titled "Recorded_Data") and 1 pop-up registration form in the start.

Click Here to Download the Report File

Report Description

About Registration Form

After opening the excel file, Report user should be able to see a pop-up window (Registration Form), titled "Registration for Data Literacy - 1107 Online Course (Data Solution - 360 x BSMRSTU Career Club)", just as shown in Figure-01.
There are total 7 empty fields (supposed to be filled by the students for registration) under the headline "Please Enter Required Information Below". Those fields are briefly introduced below:
- - 1. Full Name: This is an empty text filled where user should put his/her full name.
    2. Email: This is an empty text filled where user should put his/her mail address.
    3. Contact No.: This is an empty text filled where user should put his/her phone/mobile number.
    4. Faculty: This is an empty choice box, containing all the faculty names of BSMRSTU. Registered students from BSMRSTU should put their respective faculty name here.
    5. Department: This is an empty choice box, containing all the department names under different faculties of BSMRSTU. Registered students from their respective faculties in BSMRSTU should put their respective department name here. The department list will show in this box according to the selected faculty name from the "Faculty" box. For example, if a student select "Agriculture" faculty, then he/she will only see the following department list of "Agriculture" faculty only (Agriculture, Animal Science and Veterinary Medicine, and Fisheries and Marine Bioscience). This choice box will show empty till the previous "Faculty" box remain empty.
    6. Current Year: This is an empty choice box, containing the list of all 4 academic years (1st. 2nd, 3rd, and 4th). Student should select the year he/she is currently studying in.
    7. How did you here about our program?: This is also an empty choice box, containing the list of options from which the registered student heard about this program.

Figure-01: Opening Pop-up window of the file (Registration Form)

In the footer part of the registration form, There are 3 button fields (shown in Figure-01). Those fields are briefly introduced below:
- - - Submit: This button is used to submit the form to the system.
    - Reset: This button is used to reset the filled/half-filled form for enabling it to fill from the start. After pressing this button, the form will be a brand-new one (just like shown in Figure-01).
    - Cancel: This is the button to cancel the submission of the form. Once this button is pressed, the excel file will close down.

Conditions for Successful Form Submission:

The registration form created in this project has some special conditions to be successfully submitted & recorded. If form-filler is not able to fulfill these conditions, then his/her form will not be submitted or recorded even if he/she fill out the full registration form. These conditions are briefly explained below:

Condition-1 (No Empty Box):

If there is/are any empty box/boxes remain in the registration form, then the form will not be submitted. As it is shown in Figure-02, the field "Full Name" is empty (no value put by the formfiller), so it is showing a pop-up message box displaying "There is/are still empty box/boxes, Please fill in all the required information". The form will be submitted successfully when each and every information mentioned here are properly given.

Figure-02: Pop-up notification box (showing the existence of empty box/boxes)

Condition-2 (Valid Name):

If the name provided by the formfiller in the "Full Name" field is not a valid human name, then the form will not be submitted. As it is shown in Figure-03, the name given in the "Full Name" box is "Noor 123 sarker", which is clearly not a valid name of a person. That is why a pop-up message box appeared, saying "Please Enter a Valid Full Name!". To submit an error-free form, the formfiller should put his/her original valid name in the "Full Name" field.

Figure-03: Pop-up notification box (showing the existence of unvalid name)

Condition-3 (Valid Email):

If the mail address provided by the formfiller in the "Email" field is not a valid mail address, then the form will not be submitted. As it is shown in Figure-04, the mail address given in the "Email" box is "rayhan.ruet1559@.com", which is clearly not a valid mail address. That is why a pop-up message box appeared, saying "Please Enter a Valid Email Address!". To submit an error-free form, the formfiller should put his/her original valid mail address in the "Email" field.

Figure-04: Pop-up notification box (showing the existence of unvalid mail address)

Condition-4 (Valid Contact Number):

If the contact number provided by the formfiller in the "Contact No." field is not a valid 11-digit BD phone number, then the form will not be submitted. As it is shown in Figure-05, the number given in the "Contact No." box is "0175108738", which is a 10-digit number & not a valid 11-digit BD number. That is why a pop-up message box appeared, saying "Please Enter a 11-digit BD Number!". To submit an error-free form, the formfiller should put his/her valid 11-digit BD number in the "Contact No." field.

Figure-05: Pop-up notification box (showing the existence of unvalid 11-digit BD Number)

Notification After Successful Form Fill-up:

When the registration form is filled up properly and submitted successfully by the form-filler, there will be a pop-up message box saying "Form submitted successfully! Do you want to submit another form", just like shown in Figure-06.

Figure-06: Pop-up notification box after successful form submission

The formfiller should choose any one of the two options ("Yes" or "No") mentioned in Figure-06. In either cases, all the data filled by the formfiller will be save in the system. Both options have the following outcomes:

If "Yes" option is chosen, then a brand-new empty form will appear before the formfiller to give him/her the chance to fill the form again (This option function like the "Reset" button, mentioned in the footer part of the form).
If "No" option is chosen, then excel file will be closed down (This option function like the "Cancel" button, mentioned in the footer part of the form).

Recorded Information

After every successful form fill-up, all data is recorded in a protected hidden worksheet, titled "Recorded_Data". To open the worksheet, user must input a secret organizational password. With this way, the record of the form remains protected from the unauthorized individuals.

Page updated

Google Sites

Report abuse