Alrighty, I got the drop down lists working and returning the values they
should....BUT...still having a hitch

B7 contains a drop down list with 3 choices
*Team not present (returns a value of 0 in C7
*Team 1 & 2 (returns a value of 180 in C7)
*Team 1 only (returns a value of 100 in C7)

B8 - B12 have other drop down lists that are dependent on the choice made in
B7 and their corresponding values put in column C as well. (Actually, Column
B# looks at the score in C7 and determines what choices are available, that
was the easiest way I could figure out how to do it, and it works - EXCEPT)

Although the scores in column C are correct, If you change your choice in
B7, the spreadsheet retains the choices made in the drop down list so that it
appears that they were actually chosen until you go into the drop down and
are presented with the new choices based on the score in C7.

Bottom line, I want to be able to set a 'default' text in B# , or better
yet.... a button/key/command at the beginning of the spreadsheet that will
set all cells to blank until something happens in B7.

Also, is there a way to set the dropdown arrow to remain on instead of
mousing over?

Again, many MANY thanks for the help!!