VBA - Trying to match the value of cboPlayer1A (SHEET1) to another sheet (SHEET2) and bring back the txtPOS1a value.
SHEET2 is NOT sorted!!
Been trying different combinations with no success.
My latest error is: Unable to get the MATCH property of the WorksheetFunction class
Code:
cboPlayer1A and txtPOS1A are boxes in a form.
Please Login or Register to view this content.
SHEET2 contains Name, data, data, data in C:F
Want to match the name in Column C and return data from the other columns
Last edited by arlu1201; 04-09-2014 at 02:12 PM. Reason: Code tags
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks