+ Reply to Thread
Results 1 to 4 of 4

Using Named range to populate a Combobox in userform

  1. #1
    Valued Forum Contributor Macdave_19's Avatar
    Join Date
    03-14-2007
    Location
    Birmingham, England
    MS-Off Ver
    12.0
    Posts
    808

    Question Using Named range to populate a Combobox in userform

    HI all i have a named range called "Categories" and i was wondering if it was possible to use this in a userform as the contents of a combobox.

    i have seen a few thread using this:

    Please Login or Register  to view this content.
    or something similar howvere this doesn't seem to work?

    any idea's?

    Cheers for reading my thread and for any help
    Mr MaGoo
    Magoo.Inc MMVII

    If i've helped please add to my Rep by Clicking on the Blue Scales in the top right hand corner of the post

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Do you mean


    Please Login or Register  to view this content.

    A UserForm ComboBox does not have a listFillRange, it has a RowSource.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    05-04-2015
    Location
    New Jersey
    MS-Off Ver
    2010
    Posts
    38

    Re: Using Named range to populate a Combobox in userform

    Hi, how do i add several fields with named range dropdowns through the private sub userform_initialize() process? Stacking similar statements like the one above does not work.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Using Named range to populate a Combobox in userform

    qclady, welcome to the forum

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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