VBA Code Help with ComboBox in Userform

Can you attach what you have with the userform and any code you have? Also provide what you are getting and what the outcome is that you want.

I'm pretty sure I'll be able to help you out, but it will have to wait until tomorrow as I am about to leave for the day.

Just wanted to let you know I haven't forgotten about you. The day got away from me. After looking at your last attachment, I am thinking that you want the combobox(s) to have a list of part numbers etc. in them. If this is the case there are 4 ways (that I know of) to go about doing this. My plan is to show you 3 of them using the workbook you provided. I will give an explanation of each along with pros and cons of each. The 4th one is one that I would not recommend when multiple users are going to use it. I'll also explain why this one would be a bad idea. Hopefully you didn't need this to be done yesterday.

I see Tom is already to the rescue so I will only give you a sneak preview of what's possible.
I've been playing around with your Delivered Items userform so try it out.

In my example all works fine. Probably something to do with the Part Numbers you are using.
The error itself means that a number can't be found in Stock Sheet.
Can you give some examples of the numbers as how you put them in?

Thanks for the assist bakerman2.
EM,
I have done it another way, it's not as fancy as bakerman2's though as mine wont automatically change the description to match the part number.
This particular way requires a "master list" sheet, I have created one in your workbook. On the master list, you list your part number, description, type etc. in columns and then reference the cells for each one in the Row Source in the properties window for the combobox(s). If your lists never change, this is a ok method to use. If your list changes or needs to be added to, then this isn't the best method to use because you would have to remember to change the RowSource cell reference(s) each time you add or take away from the list.
To view/change the RowSource:
Double Click the Ordered Inventory userform
Click the Part Number combobox
In the left pane, go to the Properties - Part_Number window
Scroll down the list until you see RowSource
To the right of RowSource you will see the sheet and cell references.
I will try to get the other 2 methods to you today if you still need them.
EmcCausland-vba-code-help-with-combobox-in-userform-visual-basic-testing-book_v1.xlsm

Here are 2 other ways to do it. One way is using an array to specify what you want in the combobox which is what I did for the Part_Number combobox. The other way is with AddItem, which is what I did with the Location (ComboBox1) combobox. I did both of them in the "Received_CommandButton1_Click code for the "Received Inventory" userform. Below is the code I used

Please Login or Register  to view this content.

Here is the workbook...
EmcCausland-vba-code-help-with-combobox-in-userform-visual-basic-testing-book_v1.xlsm

I believe what is happening here is that the line before the highlighted line (the fRow =) line, is telling excel to match the part number from the Part_Number dropdown to a part number in column A. Once it finds a match, it subtracts the value in textbox3 from the value in Column C that matches the part number. Since you are adding a part number that doesn't match, it can't do what the code is telling it to do and therefore errors out because it doesn't know what to do when the part number doesn't match.