After more research, it appears inconsistent data has been the cause of the errors. I'm trying to determine if I can standardize the data or deal with the errors with error handling of some kind.
In the vloookup I'm looking for three criteria in the look-up field.
The criteria comes from the columns in the combobox.
Here is a sample of the first few columns:
PARTNUM
CORE
CORE_MULTIPLIER
ADAP_CONFIG
ENTRY_ADDER
ENV
ENTRY_SIZE
CLAMP_NBR
LEN_OPT
Sometimes there is no adapter configuration
sometimes the shell size is included in the adapter configuration field, so that if the user enters a shell size in txtShellSize, there will be an error.
And sometimes in the lookup range there is no shell size.
I was using select case to check for missing data in the lookup criteria, but I don't know how to error trap when there is missing data in the lookup range.
So maybe something will come to me this weekend.
Dan
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar