runtime error '380 Could not set the rowsource property. Invalid property value

[Pookiemeister]

Private Sub UserForm_Initialize()    ComboBox1.Value = "Please Select an employee from the dropdown"
    ComboBox1.RowSource = "Sheet1!A3:A" & Range("A" & Rows.Count).End(xlUp).Row
End Sub

Why won't this code populate my combobox? It worked for the person in the YouTube video.

Thank You

 

[steve the fish]

Do you have a sheet called 'Sheet1'

 

[Norie]

Does this work?

Private Sub UserForm_Initialize()    

    With Sheets("Sheet1")
        ComboBox1.List= .Range("A3", .Range("A" & Rows.Count).End(xlUp)).Value
    End With

    ComboBox1.Value = "Please Select an employee from the dropdown"

End Sub

 

[Pookiemeister]

Thank You both for your help on this issue. After relooking at the code after being away from it for awhile, Sheet1 was named something else. After I changed it to the correct name, it worked. Thank you again.