With two different ranges, presumably separate, you might want to add a hidden column to the combo box so you can tell where the data came from
Dim c As Range
ComboBox1.ColumnCount = 2
ComboBox1.ColumnWidths = ";0"
With Range("DU")
For Each c In .Columns(1).Cells
If c.Value <> "Empty" Then
ComboBox1.AddItem c.Value
ComboBox1.List(ComboBox1.ListCount - 1, 1) = c.Address(,,,True)
End If
Next c
End With
With Range("FU")
For Each c In .Columns(1).Cells
If c.Value <> "Empty" Then
ComboBox1.AddItem c.Value
ComboBox1.List(ComboBox1.ListCount - 1, 1) = c.Address(,,,True)
End If
Next c
End With
Also, I'm wondering about this being in the DropButtonClick event. In the Userform_Intialize event is usually where one loads a combo box. If the dropbuttonClick is where it needs to go, there should be a line clearing the combo box before it is filled (or double filled),
Bookmarks