I have a array with three columns and 38 rows. Column 1 has the holes of a golf tournament. (01A, 01B,02A, 02B, etc. through 18B) Column 2 is for the Golfers names and Column 3 the scores. Using VBA I what to search for a hole number and post a score in the third column. I have created a UserForm and ListBoxes to capture golfers names and and the Starting Hole numbers. The uses selects the starting hole number for ListBox1 and the Golfers Name from ListBox2. That codes is done, now I want to use that information to populate the array .I have tired VlookUp to find the Starting hole and locate the cell that I want to enter the Golfer but I haven't found a way to used all that to get the name in the array. Thanking y9ou in advance for any help you can offer.
Solved by A. U. in 11 mins