Write VBA code for a program that accepts four values for Customer ID, Customer name, year of birth, and age from the user and displays a message if the age is incorrect. (25%) (age = 2021 - year of birth).

Answer - 

Sub Validate_age() 

Dim age, yr, check As Integer 

yr = Range("B3") 

age = 2020 - yr 

check = Range("B4") 

If age = check Then 

MsgBox "The age is correct"

Else  

MsgBox "The age is not correct"

End If

End Sub

For Detailed Answer or Copy  of file

WhatsApp  at +91-91311223317

We Provide help in assignments.