+ Reply to Thread
Results 1 to 2 of 2

combobox activex fill

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    580

    combobox activex fill

    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.,

    Please Login or Register  to view this content.
    for one of the two buttons, where D6:Dx is a part of a column of names...


    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.
    Last edited by brucemc777; 02-17-2014 at 09:25 PM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: combobox activex fill

    The .List property shouldn't affect the .MatchEntry property.

    Perhaps you unintentionally changed the combobox's .MatchEntry property to fmMatchEntryNone?
    Last edited by AlphaFrog; 02-17-2014 at 11:22 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to fill an activex combobox with a data validation list?
    By Sape in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2013, 04:45 PM
  2. Dependency ActiveX ComboBox
    By sureshpunna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 02:37 AM
  3. ActiveX ComboBox
    By hqradio in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-27-2011, 01:21 PM
  4. Populate a activeX combobox from a selection of another combobox
    By ptramel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2009, 06:50 PM
  5. ActiveX ComboBox: Almost there!!!
    By akexcel in forum Excel General
    Replies: 2
    Last Post: 10-23-2006, 01:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1