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
Bookmarks