Populate a list on a userform combobox

[Zimmerman]

I'm sure this is something pretty simple for everyone but I'm having the hardest time getting it figured out. I have created a userform that has a
combobox. How can I assign a list that the user can pick from when they click on it. The list is on another tab named "Employee Data" and is in cells B4:B27. Also this list could grow and or shrink at any time so is there a way to have this list show in this combobox only the names that are in column B? It cold be from B4 to B50 at some point or it could be B4 to B10.

Thanks in advance
Excel 2016

 

[Akuini]

Try this:
Change ComboBox1 to suit

Private Sub UserForm_Initialize()
With Sheets("Employee Data")
Me.ComboBox1.List = .Range("B4", .Cells(.Rows.Count, "B").End(xlUp)).Value
End With
End Sub

 

[Zimmerman]

Well that was surprisingly easy. Thank you very much!

 

[Akuini]

You're welcome, glad to help, & thanks for the feedback.