Create a userform in Customers worksheet that will:

a$.$ Allow users to add information about Customers in that worksheet $($using

Userform$).$ Usersfor should have Customer ID$,$ Customer Name, Sales value and

Date of Birth section to add the information $($but not discount given$).$

b$.$ This userform should NOT ask users to record or type the $$Discount Given$$ on

the userform $($as a TextBox$).$ You as a coder should write a VBA code $($inside the

userform$)$ to calculate it in and thus, be recorded. See the conditions below: