UserForms Combobox Vlookup Not Functioning Correctly

Hello Everyone,

Thanks in advance for any assistance you provide!

I have attached a sample of the workbook I am working on. This is with the information cleaned up and examples shown.

If you click the "Create Work Order" button on the right side of sheet 1 (Work Order) it will pop up a user form. That works great and you don't need to worry about that.

The issue comes when trying to enter items. If you press the "Add More Items" button it brings you to a user form for entering item information.

I have a combobox set up to pull the manufacturers item # if there is a customer item number assigned to it. So, in theory the person doing the data entry will be able to type in or select the customer's item number and it will autopopulate the manufacturers number through a vlookup code. This works great if the customer item # is alpha numerical but doesn't work if the item # is a number. I have tried different formats, etc and it just won't work.

The other problem is the vlookup to autopopulate the item description won't pull at all.

This is my first project using userforms and so everything might be a little messy, and maybe I'm making a rooky mistake but I just can't figure it out.

Hopefully this is enough info with the workbook attached to get some help.

Here are the codes I have attached to my forms.


For The Manufacturers Item # to Be Autopopulated

Please Login or Register  to view this content.

For The Item Description to Be Autopopulated

Please Login or Register  to view this content.

To place the data from the form into the workbook:

Please Login or Register  to view this content.

To close the form and hide blank rows:

Please Login or Register  to view this content.

Thank you again!!

Mandy

Originally Posted by Norie

If you are using a contiguous range to populate the combobox you can use its ListIndex property to determine the row the selected item came from.

I'd post some code but it's not really clear where the problem lies - I get errors with both the Vlookups.

Thank you for your reply!!

I'm sorry, I'm not really sure what you mean by your first comment. Are you saying I can look it up based off of the row instead of the item # itself?

Also, is there a better way to autopopulate the data than to use vlookup? I'm really probably out of my league here.

Originally Posted by Norie

Let's say you've populated a combobox with the range A1:A10 and the user selects the 4th item in the list, ie the value from A4.

That would mean that the ListIndex of the combobox would be 3, to get the row of the value that's been selected we simply add 1 to the ListIndex.

Once we have the row we can access all the other values related to the selected item.

For example to get the value in column B we could use Range("B" & ComboBox1.ListIndex + 1).Value.

That's kind of a simplification of things but like I said I'm not sure where exactly you are having problems as both VLookUps fail when I try your code.

It's strange that they fail because the first one works for me.

I will try to use ListIndex to do what I need to. Thank you very much!!