Use textbox input and VLookup to update another textbox on same userform

I'm trying to use a textbox entry on a userform to populate another textbox (or label) on the same form based on a Vlookup to a dynamic named range. I've tried doing this a number of times and ways with the Vlookup worksheetfunction and all resulted in a "1004" error. I would like to populate CanType from Can and GrossWt from Truck (named ranges CanInfo and TruckInfo). Overall goal is to drive most of the database values from code and not using lookups in individual cells - file size bloat.

Need push in right (or at least better) direction.

Because Can and Truck are integers on the LookUpLists sheet, you need to convert the values of the textboxes to integers (using CInt).

Try this:

Please Login or Register  to view this content.

Dion

Works great! Thank you!

Now I can finish the data entry form and merge it with the larger dataset and other modules. Next pint is on me.

Roy

Thank you.

I will give that a try also ... difference between brute force and finesse.

Bob