Code for combobox that is comming from a list on a worksheet

[PMRetired2012]

What im wanting to do is write code for a combobox that picks up the list for the combobox on another worksheet in the workbook. I also want a loop set up to where when i add NEW items to that list they will show up when i click the arrow for the combobox. i will give you the information im using.
my combobox is combobox 2 and the worksheet with the list is named Sheet1.
I need ALL the code written for combobox2 to make this happen


Thanks

 

[Yongle]

One way

Code below achieves what you want (for combobox placed on a userform )... using values in Sheet1, column B (starting at B2) - amend to match the range containing your list

Private Sub ComboBox2_Enter()
    Dim Cel As Range, ws As Worksheet
    Set ws = Sheets("Sheet1")
    ComboBox2.Clear
    For Each Cel In ws.Range("B2", ws.Range("B" & Rows.Count).End(xlUp))
        ComboBox2.AddItem Cel
    Next Cel
End Sub