Results 1 to 5 of 5

ActiveX Combobox listrows property being ignored

Threaded View

Leon V (AW) ActiveX Combobox listrows... 11-05-2014, 01:25 PM
Leith Ross Re: ActiveX Combobox listrows... 11-05-2014, 03:54 PM
Leon V (AW) Re: ActiveX Combobox listrows... 11-06-2014, 05:49 AM
Leith Ross Re: ActiveX Combobox listrows... 11-06-2014, 01:03 PM
Leon V (AW) Re: ActiveX Combobox listrows... 11-06-2014, 01:19 PM
  1. #1
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    ActiveX Combobox listrows property being ignored

    I have a set of comboboxes set to list the sheetnames in a document for calculating some stuff (it's not important.
    The problem I am having is that no matter what I do to the listrows property the dropdown list is only 1 item high with tiny scroll arrows when I first click the dropdown arrow. If I unexpand the list and re-expand it again it works fine it just isn't happy when it is first selected.

    I'm pretty sure it is down to the list being cleared and repopulated each time the combobox is selected so the listrow max is set to 0 before the list is populated and is not refreshed untill after the dropdown has expanded with a row count of 0. If I select the box before clicking the dropdown arrow it works fine (again I believe because the list has been populated before the dropdown is expanded).

    Anyone know how to resolve this? (I could set the showdropbutton property to when focus but I would rather have a proper solution).
    Attached Files Attached Files
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] fill listbox (ActiveX) based combobox (ActiveX)
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-31-2014, 11:25 AM
  2. ComboBox ListRows Property
    By garmstro in forum Excel General
    Replies: 4
    Last Post: 03-01-2010, 11:17 PM
  3. 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
  4. [SOLVED] Combo Box ListRows property; changing programmatically
    By GPDynamics in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2006, 01:35 PM
  5. [SOLVED] Combo Box ListRows property; changing programmatically
    By GPDynamics in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2006, 03:30 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