TextBox VLookup N00B

[mhowden42]

Hi,

I have a UserForm with. When One TextBox (TextBox2) is filled out, I want another TextBox (TextBox4) to autofill based on the results of a Vlookup. This is my first attempt at a "smarter" UserForm.

In the UserForm(Code) window I changed the automatically generated control code for TextBox2 to the following:

Please Login or Register  to view this content.

What is kind of driving me nuts is: If I change the ,range_lookup to TRUE for "approximate match" the code returns a value from the Vlookup... It is the WRONG value but it returns and populates TextBox4. When the code is run as above I get: Run-time error '-2147352571(80020005)': Could not set the Value property. Type Mismatch.

Being new to UserForms, and knowing that I can make code *like* this work on a sheet I have been frustrated. Current file contains confidential information so I have not posted it. Worksheets("VendorData") column A is a unique Number I am searching for, Column B is the vendor's name that I want returned. I suspect it has something to do with ..._Exit(ByVal Cancel As MSForms.ReturnBoolean) because I truly do NOT understand what that is doing, other than waiting until the user exits the TextBox before running the code.

Thanks in advance.

[Norie]

Textboxes contain text, so to do a lookup from the textbox value against a range with numbers you need to convert the text to a number.

To do that you can use one of the various conversion functions, eg CDbl, CLng, Val etc

Also, to avoid the type mismatch error you can check if the Vlookup has been succesful before trying to put a value in the other textbox.

Please Login or Register  to view this content.

[mhowden42]

Bazinga! Thank you!