User Form combo box data question.

[jmoore3274]

I have a user form with two drop boxes that I need to have customized a bit more than what I'm capable of at the moment. What I'm trying to do is have the drop down boxes show the name of places that are paired to unique numbers so when the user picks the name they are looking for it will input the unique number instead of the name they selected in the user form.

For example the combo box's row source is Circuit_ID which is the names of each circuit. Now each circuit has a unique number in the same row. So A:1 has the name ABBINGTON_002 and the info I need inputted would be in D:1 which would be the circuit ID number. Each row is set up the same way Column A is the name and Column D is the ID number so on and so on for a few thousand names.

I have been trying for the last week to figure this out and I have not been successful. If any one could point me in the right direction I would greatly appreciate it

Thanks!

[mikerickson]

Use a multi-column ComboBox with hidden columns

Please Login or Register  to view this content.

Then the code for the user selected item would be ComboBox1.List(.ListIndex, 3)

[jmoore3274]

Thanks a lot! This is what I have been looking for. I can definitely research more on this to make it work!