I'm trying to learn some VBA to set up a draft board for fantasy football and was hoping for some help. I currently have a table with the Player Name (column G), as well as two sets of check boxes (columns C & D) indicating whether they've been drafted by an opposing team or myself. The check boxes return TRUE of FALSE values to adjacent columns (columns E & F) which controls the conditional formatting. For example:
imgur: the simple image sharer
If possible, I'd like to set up a Userform where I can type the name of the player that gets drafted, hit enter, have a Vlookup search for the entry in Player Name (G), and return a TRUE statement to the appropriate column. I'm not sure Vlookup is the best tool for the job, but all my attempts haven't yielded anything.
Let me know if you can help, or if you need more info
imgur: the simple image sharer
If possible, I'd like to set up a Userform where I can type the name of the player that gets drafted, hit enter, have a Vlookup search for the entry in Player Name (G), and return a TRUE statement to the appropriate column. I'm not sure Vlookup is the best tool for the job, but all my attempts haven't yielded anything.
Let me know if you can help, or if you need more info
