ComboBox - Cannot select combo box options

[MistakesWereMade]

I have a combo box that has a ListFilledRange property value of a particular column in my spread sheet.

My code is fairly simple after this...

Private Sub ComboBox1_Change()


Me.ComboBox1.DropDown


End Sub

Can anyone tell me why when I click on a combo box selection from the scroll down menu, the selection doesn't appear inside the combo box? For some of the selections it does, but for some it doesn't...

Could really use help here. Any and all help is much appreciated.

 

[MistakesWereMade]

I also just found out a little more information, it seems that the reason why I cannot select other options is because only the first item in the combo box drop down is capable of being selected. Any options further down on the drop down do not fill the combo box when you click on it...