Hi, I have a combobox that lists 2426 things (less as you type in) and runs by the code:
Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
Range("F4").Value = ComboBox1.Value
End Sub
The problem is that the image of the combobox remains there as I move on to other sheets in the same workbook or when I scroll down on the sheet of the combobox. When I click on it, it disappears. How can I get rid of this image of the combobox?
Thanks a lot!
This assumes ComboBox is embedded in the sheet, not on a userform
With these 4 subs in the relevant sheet module:
- double click on the ComboBox and it disappears
- double click anywhere in the sheet and it re-appears
- leave the sheet and it disappears
- return to the sheet and it re-appears
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks