Using VBA Excel and Option Explicit and IPO Please :)

Exercise: Xoop panel candidates

Elections are coming up on Xoop, a planet about 58 light years from Earth. Plinth, a political journalist, wants to form a small panel of average citizens, and get their opinions on the issues. She has a list of volunteers, but most of them are not suitable. Write a VBA program to go through the list, and show potential candidates.

Download this workbook with data on Xoop volunteers. Heres part of it:

The first column is the volunteers name. The second is the length of the volunteers primary tongue, in etels (an etel is about a meter). The third column is the number of oths the xoop has. An oth is a combination leg and mouth.

Plinth wants to find xoops whos tongue is at least 1.8 but no more than 2.3 etels long, and has at least 4 but no more than 7 oths. Heres what part of your worksheet should look like after the code runs.

The candidate xoops are listed, with their tongue and oth data. The statistics are just for the candidates. So 2.13 is the average tongue length for the 11 candidates who meet Plinths criteria.

Round the averages to two decimal places.

Write your program so that it adjusts if the number of rows changes. If some volunteers drop out, or others are added, your program should analyze the new data, just by clicking the Run button.

Assume that all of the data is valid and accurate.

Normal coding standards apply.

Tongue oths 1 Xoop 2 Oh'abehr 2.71 3 Ey'legin 2.36 9 4 Zy'adnalor 1.71 9 5 Me'ailel 1.62 6 Ht ylrehs 1.42 4 7 Hq'nlocnil 1.3 10 2.21 8 Tt'lyrem. 10 9 Ym'apilef 2.67 10 10 Nyyssim 1.13 9 3 11 asi 2.11 4 12 Dj'ahte 2.45 13 Tyttemme 2.44 10 14 Bv'llirrem 2.83 Run Candidates Number: Avg tongue: Avg oths: Total oths: Tongue oths Xoop