ComboBox list of names

Hi I have a userform for sheet1 with a combobox on the userform I have commandbutton I am trying to get a list of names from sheet1 A1:A250 to go in the combobox1

the code I have is not working

Private Sub CommandButton1_Click()

Sheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Offset(1).Value = TextBox1.Value

Sheets("Sheet1").Cells(Rows.Count, "B").End(xlUp).Offset(1).Value = ComboBox1.Value
Sheets("Sheet2").ComboBox1.List = Range("A1:A200").Value

TextBox1.Value = Date
ComboBox1.List = Name

Please use code tags in future.


What is Name in your code?

ComboBox1.List = Name

Does the combobox on the worksheet get fill correctly?

If so use syntax similar to that

ComboBox1.List = Range("A1:A250")