+ Reply to Thread
Results 1 to 7 of 7

Set List Box Source To Worksheet

  1. #1
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Set List Box Source To Worksheet

    I have a worksheet called Names - and have added a userform to my workbook. I want to set the control source (or the display text whatever it's called) to be my worksheet called Names all of row A except the top row the header. How do I do this?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Set List Box Source To Worksheet

    If you mean all of column A bar the header row then you can use this to populate the listbox.
    Please Login or Register  to view this content.
    Or, alternatively, if you want to use RowSource this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Re: Set List Box Source To Worksheet

    Using your 1st solution - I get a permission denied error when the form goes to load. The offending line is the
    Please Login or Register  to view this content.
    line

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Set List Box Source To Worksheet

    Are you already using RowSource for the ListBox?

  5. #5
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Re: Set List Box Source To Worksheet

    No - my project has this VBA
    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Set List Box Source To Worksheet

    Any chance you could upload a sample workbook?

    Click on GO ADVANCED, scroll down and click Manage Attachments.

  7. #7
    Forum Contributor
    Join Date
    06-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    546

    Re: Set List Box Source To Worksheet

    I found it. Someone had added the record source in the properties of the form and not in the VBA. I was only scanning the VBA originally.

+ 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. Replies: 2
    Last Post: 09-28-2016, 02:09 PM
  2. [SOLVED] Make D.V. list dynamic even if source list is linked to other cells that are empty
    By kosherboy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-24-2015, 07:35 PM
  3. [SOLVED] Output in same worksheet as source removing source data
    By macrolearnerkk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2015, 03:50 PM
  4. [SOLVED] Output in same worksheet as source removing source data
    By macrolearnerkk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2015, 03:49 PM
  5. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  6. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  7. Dynamic combo row source - works only if active source worksheet
    By fredpox in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-21-2010, 07:16 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