VBA CODE

Data needed to do the problems is on this link

https://www.contextures.com/xlSampleData01.html

Write a code using VBA that:

' Create a UserForm with a single-select ListBox. Initialize it with unique names of 'sales reps. ' use the AdvancedFilter method and temporarily store 'the unique names somewhere in the worksheet. ' Add a CommandButton (NO Button form control) to the UserForm to calculate 'the Total sales of the selected rep and show the result in a TextBox control. ' Add a Button (form control) in the WS to open this UserForm.

' Create a UserForm with 7 TextBox controls and a CommandButton to add a new 'record (with the 7 input values: OrderDate, Region, ...) at the bottom of the WS