VBA: use external file as DB and combobox for drop down list selection: confused and lost

Hi all

I have had several people offer help for my delima, and I am now having issues. I have probably mixed and confused the assistance from others to the point where when I attempt to run my code, I am somewhere lost in an infinite loop and I can not even get my userform to come up. I have attempted to debug and step through to no avail, still, can not determine where my issue is.

SO, I am posting my entire code here, with an explanation of what I am attempting to do in hopes that someone smarter than I am with VBA is willing to assist me in getting past this point. I feel that my code is close to finished for what I have been asked to do by my boss.

What my program is supposed to do:

It opens a page for a receiving report. The code should get the data for the combobox dropdown list of the part number (Partno and then description) from a file off what we call our G: drive. This file has 2 columns, column A is the part numbers and column B is the description. This has to be used as we are continually updating with new parts and /or revised part numbers from our customers.

The user then selects the part number from the dropdown selection, and its corresponding description comes up in the combobox. I am needing to keep the part number in a variable called Partno and the description in a variable called Description for use later in the program. My main issue was getting both of these into their respective variables for use later.

What is happening:

NOW--- I am in this loop where I click on the Receive Product button and there is an infinite loop. Prior to this happening, the userfomr would load and the dropdown list would be populated. Then my next issue is

I keep getting an error in the procedure called sub cbPartno_change
specifically on the code with cbPartno
Partno = .List(.ListIndex, 0) I either get subscript error or list not found.


I appreciate anyone who can assist me on this.