vlookup in vba

[kstv]

I keep getting "Error 2042". See code snip bellow:

Please Login or Register  to view this content.

Not sure why I keep getting Error 2042. Please advise.

Thanks,
Stephen

[TMS]

Welcome to the forum. Please take a few moments to read the forum rules and enclose your code snip in CODE tags ... before anyone can offer advice or assistance.

Regards

[TMS]

Just as a quick answer ... in the expectation that you will add code tags.

It's not a good idea to use Excel and/or VBA function names as variables, subroutines or functions.

LOOKUP is a standard Excel function so it might give VBA a headache.

Regards

[kstv]

Thanks. I changed the function name to FindZipCode. I still get the same error.

[TMS]

Please post a sample workbook with some typical data with the code in context. I'd like to see an example of how you are using this function.

Regards

[kstv]

see attached sample code.

I have two files. Main file and the validator file. I cannot place any macros in the main file so I need to interact with the main file using another excel file.

All I need to do is post the city, st, and county information in the main file. The main file contains 47,000 rows. I tried using a DO WHILE look and it took too long to complete. The VLOOKUP function is much more robust but it is not cooperating with what I need to do.

Please advise.

Thanks,

Stephen
New Text Document.txt

[tigertiger]

Why don't you post excel file and say what you need and expected result?

because reading the text file is not easy to understand what your need is

[kstv]

Sorry about that.

Please see attached.

project_file.xlsx
zip_code_validator.xlsm

[kstv]

both file needs to by opened and ctrl+g from zip_code_validator to launch the form.

Thanks again.

stephen

[tigertiger]

both file needs to by opened and ctrl+g from zip_code_validator to launch the form.
stephen

It is confusing for me to read your long code

therefore, I just make a sample sub (see in module 2) that makes the same result as your need, I hope you can understand what it run and correct it appropriated to your problem,

see the sub in module 2 from attached file,

Please Login or Register  to view this content.