[SOLVED] userform vlookup 424 error

[adamheon]

I'm having in issue with the code below. I believe the issue is the name of the worksheet and how it's listed in the code. The worksheet that the dynamic range "Lookup" is in is called "CLIENTS"....but if I put that name as shown below i get a 424 error. If i rename the worksheet to Sheet1 and change the name in the code to match, I dont get the error but the vlookup doesn't work.

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Why are you using CLng in the lookup? What does Me.arcode contain exactly?

I assume "CLIENTS" is a sheet and has been defined as such elsewhere in the full code?

BSB

[adamheon]

i'm using CLng because you using a numeric to do the VLookup.

arcode = the name of the text box that you would type in the numeric lookup

I did not define CLIENTS anywhere....the code i posted is the full code.

[BadlySpelledBuoy]

Does this work?

BSB

Please Login or Register  to view this content.

[adamheon]

It sure did! Thank you!