+ Reply to Thread
Results 1 to 3 of 3

Error With Assignining A NAmed Range To Combobox list property

  1. #1
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Error With Assignining A NAmed Range To Combobox list property

    I am getting an error ("Could not set the list property. Invalid property array index") assigning the list property of a combobox to a named range.

    Please Login or Register  to view this content.
    Last edited by Jenn68; 02-01-2019 at 11:53 AM.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Error With Assignining A NAmed Range To Combobox list property

    Try
    Please Login or Register  to view this content.
    Depending on the shape of ai_typelist, you mgiht have to Transpose the .Value
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Error With Assignining A NAmed Range To Combobox list property

    That worked Mikerickson! Thank you.
    What's odd about my question, is that I'm cleaning up my existing VBA project which worked without error (it just wasn't very efficient) and my original line did work in populating the combobox without the extra code. Fluke?

    Anyway ... it works which is all that matters.

+ 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. [SOLVED] How can I get my combobox list to fill with a range without using rowsource property?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-09-2017, 01:06 AM
  2. [SOLVED] Use Named Range to set ComboBox List?
    By Merf in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2017, 09:18 PM
  3. VB UserForm ComboBox List Based On Dynamic Named Range in Worksheet
    By huntethic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2015, 02:45 PM
  4. [SOLVED] ComboBox add entry to Named Range if not in list
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2014, 03:36 PM
  5. [SOLVED] Populating ComboBox using dynamic named range - Error
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2014, 05:42 AM
  6. setting a combobox list property to a named range
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-06-2012, 11:52 AM
  7. Dynamically assign ComboBox.List from named range areas
    By Paul Martin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2005, 01:05 AM

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