When I switched from filling the combobox from a stated range in listfillrange to using vba and the .list property, I noticed that when I type in the combobox it no longer searches for the next matching value. Is this inherent? Did I break something? Can I fill it using the .list property and still have it search for the next matching value?
It is VERY possible I monkeyed around with something else and broke it.
As part of the changeover to using .list, I placed two radio buttons on the worksheet which control what fills the .list, if button "A" is selected it hase a range of names set for the list, if buttone "B" is selected it uses a range of numbers; i.e.,
for one of the two buttons, where D6:Dx is a part of a column of names...Please Login or Register to view this content.
edit: In retrospect, I must have done something wrong. When I select the combobox by clicking on the "down arrow" to open up some of the selections, then scroll my mouse wheel, instead of the entries scrolling the page scrolls down with the window of selections scrolling down from it's original position also, separating downwards from the bar where the result would be. Call an exorcist.
Bookmarks