Results 1 to 20 of 20

Populate Userform List box with table data on another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-13-2014
    Location
    Three Rivers
    MS-Off Ver
    365
    Posts
    129

    Populate Userform List box with table data on another sheet

    Hi,

    I hope someone could help with VBA code to populate a list box on a user form that gets the it's data from another sheet (DB) with all the data in a table. sheet attached

    I need two things to happen with this user form:

    1. When the All Staff button (Grey button) is pressed on the user form then the list box (Resultbox) must get populated with staff detail of the following columns: Name, Last Name, Branch, Cell Number for ALL the staff listed on sheet (DB).

    2. When the Current Staff button (Blue button) is pressed on the user form then the list box (Resultbox) must get populated with staff detail of the following columns: Name, Last Name, Branch, Cell Number for only the staff that are currently employed and this is determined by column N which says if they are employed or not.

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Populate and configure List box (Userform) from a dynamic range of data.
    By thebeastslayer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2020, 05:53 AM
  2. [SOLVED] common userform for sheet 1 and sheet 2 but need data to populate from a different row
    By dav2020 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2019, 08:33 PM
  3. [SOLVED] populate userform with data from pivot table
    By Mathijs3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2016, 10:30 AM
  4. [SOLVED] Populate userform text boxes with dater from another sheet, dependant on list box selectio
    By MallorcaPete in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-17-2015, 07:01 AM
  5. Populate Excel table with userform data
    By waspandbee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2010, 09:34 PM
  6. [SOLVED] Populate a comboxbox and Listbox in a excel userform with an sql table data
    By abhay_547 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2010, 04:58 PM
  7. Populate multi-column list in sheet not in UserForm
    By afzal001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2008, 12:26 PM

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