Scoresheet Template

MrRubix · 05-20-2008, 12:59 PM

Download link: http://www.mediafire.com/?tindmxzihs9

This is a very basic version of an automatic rank-generator. You type a name and their corresponding score, and it will insert as needed.

If you wish to rank people by some number (e.g. time) where a LOWER number is better than a higher one, then you need to change one line of code in the VBA editor (Tools->Macro->Visual Basic Editor):

If insertscore <= Cells(i, 6) And Cells(i, 1) <> "" Then
should be changed to
If insertscore >= Cells(i, 6) And Cells(i, 1) <> "" Then

Other than that this should all work fine. Feel free to edit the code as you need depending on what you wish to use it for.

05-20-2008, 12:59 PM	#1
MrRubix FFR Player Join Date: Dec 1969 Location: New York City, New York Posts: 8,340	Scoresheet Template Download link: http://www.mediafire.com/?tindmxzihs9 This is a very basic version of an automatic rank-generator. You type a name and their corresponding score, and it will insert as needed. If you wish to rank people by some number (e.g. time) where a LOWER number is better than a higher one, then you need to change one line of code in the VBA editor (Tools->Macro->Visual Basic Editor): If insertscore <= Cells(i, 6) And Cells(i, 1) <> "" Then should be changed to If insertscore >= Cells(i, 6) And Cells(i, 1) <> "" Then Other than that this should all work fine. Feel free to edit the code as you need depending on what you wish to use it for. __________________ https://www.youtube.com/watch?v=0es0Mip1jWY Last edited by MrRubix; 05-20-2008 at 01:03 PM..

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)