+ Reply to Thread
Results 1 to 8 of 8

combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

  1. #1
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    I have a few comboboxes in my workbook which work wonderfully, however.....

    They all take their ListFillRange from named ranges arranged vertically in a column.

    The new combobox needs the ListFillRange to be taken from a range held horizontally - 'Simples' I thought, a range is a range afterall....

    I have the ListRows set at 20, however the only option for selection is the first cell of the horizontal range and it's only the first item from the list.

    Is there some limitation around lists only being stored in columns or is there a workaround?

    Cheers.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    Perhaps something like this:-
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    Simple yet brilliant!

    Didn't think to manipulate the list in transit - I though't I'd have to transpose on another sheet and pull it form there, however as this needs to be a 'live' list, it would have caused problems.

    Thanks!

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    I reckon
    Please Login or Register  to view this content.
    Should work without the transpose

  5. #5
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    Quote Originally Posted by Kyle123 View Post
    I reckon
    Please Login or Register  to view this content.
    Should work without the transpose
    Getting Invalid property array index with this one should it replace
    Please Login or Register  to view this content.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    Oops, try:
    Please Login or Register  to view this content.
    Last edited by Kyle123; 11-17-2014 at 05:53 AM.

  7. #7
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    That works perfectly and it also nearly solves the date formatting as it pulls in a date format instead of displaying by numbered format - just need to get it to display the right date format as
    Please Login or Register  to view this content.
    seems to be having no effect.

    Oh well, that's an entirely different issue

    Thanks for the hlep.

  8. #8
    Forum Contributor
    Join Date
    09-17-2014
    Location
    UK
    MS-Off Ver
    2007
    Posts
    117

    Re: combobox (ActiveX) ListFill, ListRows & Horizontal Ranges

    Actually - the date reformatting did work. My PC began to run like a bag of spanners for about 10 minutes and then when I ran it again, the dates were correct.

    Hope it's not some of my code causing performance issues

+ 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. ActiveX combobox datalist dependant on previous combobox selections
    By Mrs Poodle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2014, 07:07 AM
  2. [SOLVED] ActiveX Combobox listrows property being ignored
    By Leon V (AW) in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 01:19 PM
  3. [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
  4. ComboBox ListRows Property
    By garmstro in forum Excel General
    Replies: 4
    Last Post: 03-01-2010, 11:17 PM
  5. 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

Tags for this Thread

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