Hello

I've searched the forum and found a few responses to this which suggest using a listbox vs a combobox. I have played around with the bound and textcolumn properties and i cannot seem to get the combobox to show both columns of data which is what I need. Any suggestions with the code below?


Private Sub UserForm_Initialize()
Range("A3:B3", Range("A3:B3").End(xlDown)).Name = "MyRange"
Me.ComboBox1.RowSource = "MyRange"
End Sub