Visual Basic Application Problem

http://imgur.com/a/1qdEz

^^^^^^^^^^

Please check link. I took a photo of the whole question and examples it was using.

I am using Visual Basic for this problem. From the "Starting out with Visual Basic 7th Edition" Book.

Question:

Rank three boats finishes from four boat races. (3 rows: Boat#1, Boat #2, and Boat#3) (6 columns: Race 1, Race 2, Race 3, Race 4, Total, Rank)

Rank the boats from a sailboat race. Assign them first, second, and third place. Perform the following input validations:

1. All input values must be valid integers.

2. In any column (a single race) the three integers must add up to 6 (1 + 2 + 3, in any order). We assume there are no tie scores.

When one of these input validation fails, display an appropratie message in the status bar. You do not need to customize the message for each input field, but you must explain the nature of the error (nonnumeric, or duplicate values for a single race). For example, if the user enters the rankings incorrectly for Race #1, the error message on bottom says "Enter 1, 2, and 3 only for Race 1." If all inputs are correct, display the rankingsfor each boat (1,2,3) in the Rank column. It is possible for two or more boats to have the same total race score. In that case, display the word "TIE" on the status bar, an turn the font color for all three scores to the color Red.

Note: There are six ways of arranging the rankings of three sailboats, so your nested IF statement must be able to create these arrangements. The arrangements are: (1,2,3),(1,3,2),(2,1,3),(2,3,1),(3,1,2), and (3,2,1).

Some photo examples for the application are in this link

http://imgur.com/a/1qdEz