+ Reply to Thread
Results 1 to 2 of 2

Setting a name as a ComboBox list range

  1. #1
    Registered User
    Join Date
    05-07-2015
    Location
    Angouleme, France
    MS-Off Ver
    2013
    Posts
    48

    Setting a name as a ComboBox list range

    Hello,

    I just discovered a way to make a dynamic list range and store it as a "Name".
    I know how to use it in a drop-down list, but how can I do the same with a ComboBox ?

    Can I call the name as the ListFillRange, or do I have to write the full Name formula ?

    ---
    If you are interested, here is the formula :
    Please Login or Register  to view this content.
    Considering the list content starts in A1 and is contained in the whole column
    ---

    Thank you for your help !

    François

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Setting a name as a ComboBox list range

    if you are talking about ActiveX in the spreadsheet (not forms) then yes you can just type in the name of the named range

    as you are using volatile data
    probably should set autoload = true as well
    Last edited by humdingaling; 05-20-2015 at 10:44 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Combobox dropdown to list range from sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-30-2013, 12:35 PM
  2. 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
  3. [SOLVED] Setting a Range Variable to a Filtered List
    By StevenM in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-29-2012, 07:06 PM
  4. Setting ComboBox.RowSource via Named Range
    By RobertL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2007, 08:19 PM
  5. [SOLVED] setting a range using a named list in vba
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-12-2005, 02:06 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