vlookup in vba

[mubashar]

plz guide me whats wrong with my code

run vba userform and when i entered value in textbox 1 and click on form ... it will give error. plz correct it

[xlbiznes]

change your code to this :

Please Login or Register  to view this content.

this is because your key column is a number and not a string so val will convert appnum into a number

[mubashar]

thanks for your quick and correct reply

[xlbiznes]

You are welcome,

Please mark this thread as solved if you are satisfied with the solution provided.