Dropdown list on VBA form

[ExcelNovice]

I'm trying to add a simple drop down list to a VBA form. The list will have only two items from cells OK65 and OK66 of the active sheet.
Can someone help me get this dropdown list to work?
This is the code I'm using:

Private Sub cbofield_Change()


cbofield.List = ActiveSheet.Range("ok65k66").Value


End Sub

Above does not work; please help.

Thanks

 

[DanteAmor]

Change your code for this :

Private Sub UserForm_Activate()
    cbofield.List = ActiveSheet.Range("ok65:ok66").Value
End Sub

 

[ExcelNovice]

Great, thank you, it works!

 

[DanteAmor]

Great, thank you, it works!

I'm glad to help you. Thanks for the feedback.