Go to Client worksheet. Create a userform for Client worksheet using VBA that will: a. Create a command button and allow

[answerhappygod]

Go to Client worksheet. Create a userform for Client worksheetusing VBA that will:a. Create a command button and allow users to add information aboutClient in thatworksheet (using Userform).Userform should have ClientID, Sales, and Date of Birth labels toadd theinformation (but not discount given; see below for more informationon the“discount given” column).This userform should NOT allow users to type the “Discount Given”on theuserform (so do not ask for it as one of the TextBox). Instead, youshould writeyour VBA code INSIDE the same userform in such a way that itcalculates the“Discount Given” - use the reasonings and conditions provided inquestion (i)below.
2i. If the customer’s birthday is today, we give the customer adiscount of10% of the sales value. For all other customers, born on adifferentdate, the discount should be 2% of the sales value. For example, onD9,you should have a $$ number (i.e., which is 10% or 2% of value onB9)depending on if the date of birth given on C9 shows that theperson’sbirthday is today.b. Make sure your userform is captioned as “Client Form” instead ofuserform1 (oruserform 2 (but do not change the name; just change the caption)and has abackground picture (of anything; feel free to download a picturefrom theInternet)Note: For the question above, NO need to create SEARCH button inyour userform as thequestion isn’t asking that. Also, NO need to create REFRESH buttonin your userform.