Hey All,
I haven't done any sort of VB or any programming since college, and that was 15 years ago (yikers). Last year, I got a wild hair to build a "simple" sheet that would allow us to partake in an offline fantasy football draft. For slapping it together, and not really knowing what I was doing, it worked rather well (a few bugs trying to set focus if we tabbed to different sheets). It's a table that has a dropdown menu and command button. When we start typing a players name, it auto populates and we can click submit, at which time it pastes a formatted value (like Todd Gurley - RB - LAR, in a red box to denote RB). Fast Forward to today, I'm trying to clean it up and update it with this years player list and I'm running into issues:
What it's doing now:
* it's not tabbing over to the next cell after the command click and the value gets pasted
* when I do hit tab after the command click, the next cell, which was getting focus last year, isn't and it takes 2 or 3 attempts of clicking the cell and the combo box to get the values to take
* If I tab away to look at available players and come back, or jump to previous or much later cells, the combo box starts to populate the typed player, but when I select the value in the drop down list, it goes blank. Takes 2 to 3 tries also.
What I'd like it to do to finish it up
* fix the issues above
* let me know if a duplicate player is in the range (tried it, but it would only return me the statement for a false value)
* as players are selected, live update the drop down list, so as we type a previously taken player won't populate or show up (I have a second worksheet that has a true/false value if they've been selected and can manually update, but couldn't
figure out how to tie it to drop down / combo box.
* default to the first name in the drop down, so if I begin typing Tyreek Hill, that it selects his name (since he's the only Tyreek) and can hit Enter to populate instead of click his name in dropdown, click sumit, and tab to next cell.
I've attached a screenshot of last years as well as attached my test files for this year. I'd greatly appreciate any help on this. I know just enough programming to mess things up, and even then, it's rusty, lol.
Thanks
draftboardshot.jpg
Bookmarks