Avatar of Pelin Tasci
Pelin Tasci

asked on 

Combobox appearance issue

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
Microsoft OfficeVisual Basic Classic

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon