Pull Down List using data from multi sources

[Snowshoeken]

I need to make a pulldown list of what is essentially 11 digit codes that are listed on different tabs. There are some duplicates. In the end I want to place this pull down list in a User Form. Any ideas? Thanks.

Snowshoeken
"Realizing you have nothing, allows you to do anything."

 

[Snowshoeken]

Works perfect. Have another Q. Now that i have got my list ready, I want it to imput my choice into a cell that is the basis for a vlookup and some subsequent calculations. How do I have the "choice" from the list appear in a specific cell? should I start a new thread for this questions? Thanks again.

Snowshoeken

 

[Andrew Poulsom]

Just add some code to the ComboBox_Change event procedure, eg:

Private Sub ComboBox1_Change()
    Worksheets("Sheet1").Range("A1").Value = ComboBox1.Value
End Sub

Change the sheet and range references to suit.