Hello all!

I'm trying to throw together a spreadsheet to use during large Trivia events I score. I'm using Excel now, but I'm worried that a couple mis clicks could cause a disaster in the middle of a 200 person event, so I'm trying to streamline things.

As of now I have a Column A populated with Team names, and then have Column B, C, D, E and D to hold the scores for each respective "trivia round". Then Column E is the sum of the rounds to total the scores. So a pretty basic doc at this point.

I was thinking that creating some user forms to enter in each teams scores for a round would make the process more straight forward and less error prone. I've been able to create a userform, create a listBox and populate it with the team names. From this point the logic of creating the script to transfer a score entered into a text box on the userform in the round 2 box for the team selected is proving difficult. I'm a Perl programmer, but this is a different animal.

Any suggestions that anyone could give me would be awesome, and I would be immensely grateful!

Regards,
Dan