VBA - adding list validations to a userform

[Macroni and cheese]

I'm trying to validate a list in a combo-box from a name range from a seperate worksheet.


MY Combo box = Team
MY name range = Workstream

the code I am trying to work with is

'fill Team
With Team
.List = Range("Workstream").Value
End With


but is not working, can someone please tell me where I am going wrong??

 

[Macroni and cheese]

I've got it, thanks anyway!