Userform

[vkeller]

I have a Worksheet that is a grid for an NCAA pool. It has 100 squares in it and I would like to create a userform to easily enter the players names in all of the squares. I don't know a lot about VBA but have a little experience with it! Any help would be appreciated!

[Leith Ross]

Hello vkeller,

Welcome to the Forum!

Your workbook has been downloaded quite a few times. I think the reason you have not received any answers is due to the lack instructions in your post. You did not provide a before and after example in the workbook. How are people helping you going to know what you want if you don't show them or at the very least provide them with directions?

[vkeller]

Ok, I will try to explain a little better. We are having an ncaa pool and I have built an excel spreadsheet to track all of the scores. We have a grid of 100 squares that we have and will get friends and families to fill out each square with their name. I have attached a better example. Basically, we print out the grid and it is blank. Even the numbers on top aren't showing. When we get all the squares filled with friends and families names we will draw random numbers to go across the top and the left side of the grid. For my spreadsheet to work I have the numbers set 1-0 on the top and 1-0 on the left side. What I was wanting to do is to take the paper we have filled out with all the names and input it in to the grid I have via a userform and to match the numbers they have on the paper with the numbers set on my spreadsheet. Just to make it easier to input I thought a userform may be easier to use! Thank you!!