ComboBox-on-Sheet.xlsm

<div>
<div class="content wysiwyg-content">
Hi,<br />
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:<br />
<br />
Private Sub ComboBox1_Change()<br />
ComboBox1.ListFillRange = &quot;DropDownList&quot;<br />
Me.ComboBox1.DropDown<br />
Range(&quot;F4&quot;).Value = ComboBox1.Value<br />
End Sub<br />
<br />
How can I get rid of this image of the combo box?<br />
<br />
Thanks,<br />
Pelin
</div>
</div>


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

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 = &quot;DropDownList&quot;
Me.ComboBox1.DropDown
Range(&quot;F4&quot;).Value = ComboBox1.Value
End Sub

How can I get rid of this image of the combo box?

Thanks,
Pelin

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.