1. Your program should have a command button on the first worksheet for executing your procedure, which when executed should display each score on a separate line as below:

Here are summary measures for the scores: Average: .. Stdev: Min: .. Max:

I need to display it in one input box the number ranges from A1:A100 for example, I just need what codes to figure out these measurables.

2.

I need to display input box right when I open it and it ask what is your name, when entered a name it updates A21 saying updated by "name", after that another inputbox asking for commission rate for "B1" I do not know how to open input when it opens.

B A Commission rate: 1 2 3 Salesperson 4 1417 5 1428 6 1430 7 1578 8 1599 9 1601 1604 11 1689 12 1743 13 1788 14 1811 15 1822 16 Total 17 18 19 20 21 Updated by Sales 23,000.00 56,000.00 34,000.00 19,000.00 35,600.00 23,600.00 12,500.00 56,700.00 21,300.00 12,000.00 45,900.00 32,100.00 $371,700.00 Commission 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $0.00 10