Hard Code 3000 records in invisible list box; need to loop
There are over 3000 records currently. For example, the user puts the Product Code in the textbox and then the description that matches that Product Code should automatically populate in the Description textbox (which will be read-only).
The manager wants no DB connection for this form and the information is in an Excel table.
However, I basically want to put the Product Code and Description into an invisible list box and then loop through the list box to match up the description for the product code the user enters and put that information into the Description textbox.
Can anybody help? I am currently hardcoding until I can figure out my looping code.