Hi,
I have a combobox on one sheet that displays +2000 things from a list from another sheet. The problem is: When I scroll down on the sheet of the combo box or I go on to another sheet, the image of the combo box remains at where it used to be. When I double click on it, it disappears. Otherwise, the combo box functions properly. The code is as follows:
Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
Range("F4").Value = ComboBox1.Value
End Sub
How can I get rid of this image of the combo box?
Thanks,
Pelin