Hello Fellow Programmers! I am having a difficult time trying to get my
user form to search through a spreadsheet and retrieve the information
using the Application.Vlookup code...I have searched numerous other
posts and haven't found one code that worked the way I needed it to.

Private Sub TextBox10_Change()
x = Application.VLookup(TextBox10.Value,
Worksheets("SYSDATA").Range("A2:J30"), 2, False)
TextBox1.Value = x

End Sub

The objective is I have a Record Number listed in TextBox10... I have
information setup in the spreadsheet that I would liked filled in
TextBoxes 1 - 9 based on the value of TextBox10. I have tried to use
the code above to work but it keeps giving me a error message saying
"Could not set the Value property. Type Mismatch"...So my question is
how can I have my 9 other text boxes use the Vlookup code (using the
value from Textbox10 as the search value, to retrieve the information
based on its value?) TextBox10 will always be a number (for now)...I
might need the code to lookup the value of a non-numerical string at
some point but I'll be happy with just having the vlookup code work.
Any help is greatly appreciated!!!