GUSS Scouting System

[JesseK]

Originally Posted by wilsonmw04

ok, I've been playing with it for a bit and I've run into a few things:
1. When I populate my list of teams, they are not populated as a "hyperlink"
2. When I create new matches from my list and try to save them, I get an error: run-time error '1004' Unable to get the Vlookup property of the WorksheetFunction class.

I select "debug" and it points me to this line of code:
rownum = Application.WorksheetFunction.VLookup(WorksheetFun ction.Text(Str(teamnumber), "@"), Range("A2:Z500"), 19, False)

it seems to be in the part of the code that sets the new value in team page.

After playing with it a bit further, I too encountered this. After some investigation, it looks like it's a formatting error.

If you manually enter in each team number on the team list tab, the cells are formatted incorrectly and you will get this error. Hence, you need to copy/paste in a team list from somewhere else.

If you manually enter in the team #'s on the matches tab, then double click the match number, you see that in the 'notes' section you have your team #'s right aligned, whereas the original copy has them left-aligned. You also cannot double-click the team here or on the matches page to automatically go to that team's tab. The workaround for this one is to copy each team # cell from the team list tab over to the matches tab. Then it works perfectly.

Starting with the original, if you manually enter team numbers (e.g. 1130) for a new match, you will get an error that says the team is not found in the team list. This furthers my suspicions that all of the VLOOKUPS look at formatting.

Ok, so some bugs, and some workarounds, but I still like it

[wilsonmw04]

Originally Posted by JesseK

After playing with it a bit further, I too encountered this. After some investigation, it looks like it's a formatting error.

Ok, so some bugs, and some workarounds, but I still like it

I sort of ran into the workaround on accident when loading my old list into the new version. I did a cut and paste of my old list into the new sheet and problem solved. Things look really good so far. I look forward to playing with this a bit while watching the webcast of DC this weekend.

[theCoder]

Originally Posted by JesseK

After playing with it a bit further, I too encountered this. After some investigation, it looks like it's a formatting error.

If you manually enter in each team number on the team list tab, the cells are formatted incorrectly and you will get this error. Hence, you need to copy/paste in a team list from somewhere else.

If you manually enter in the team #'s on the matches tab, then double click the match number, you see that in the 'notes' section you have your team #'s right aligned, whereas the original copy has them left-aligned. You also cannot double-click the team here or on the matches page to automatically go to that team's tab. The workaround for this one is to copy each team # cell from the team list tab over to the matches tab. Then it works perfectly.

Starting with the original, if you manually enter team numbers (e.g. 1130) for a new match, you will get an error that says the team is not found in the team list. This furthers my suspicions that all of the VLOOKUPS look at formatting.

Ok, so some bugs, and some workarounds, but I still like it

I never saw the problem with the teams because I cut & pasted the list. I also ran into another vlookup issue with formatting. Today I was working on a "my team" page and I ran into problems where the team # was not being found in the team list.

Stay tuned....