+ Reply to Thread
Results 1 to 3 of 3

Populate dropdown menu in userform based off cell value

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Populate dropdown menu in userform based off cell value

    I have a UserForm that allows a location to put in a container # & their driver ID. I would like for it to look in sheet "Employees" in column B to find the location that is defined in Label3 of the userform & then populate the Driver ID numbers in the Listbox1 menu in the userform. Any help would be greatly appreciated. I have included a sample file to help you understand what I am trying to achieve.
    Attached Files Attached Files

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Populate dropdown menu in userform based off cell value

    Let's start with this.
    Please Login or Register  to view this content.
    Last edited by bakerman2; 06-14-2018 at 08:38 PM.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Re: Populate dropdown menu in userform based off cell value

    Great that works - now if the submit button. Is there away that it can connect to a workbook called "ART Project for Off-Books" and look at the location in the label on this userform & copy the driver ID # to the worksheet with with the same name as the label in column K based on if the container # on the userform is equal to the container # located in column D?

+ 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] Input cell value based on multiple dropdown list to populate
    By Anisusa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2017, 07:15 AM
  2. Populate chart series name from text in dropdown menu box.
    By Montana2014 in forum Excel General
    Replies: 2
    Last Post: 11-27-2016, 10:54 PM
  3. [SOLVED] Populate in-cell dropdown list with values based on sheet name
    By mks16 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-21-2015, 09:35 AM
  4. Populate cell based on drop down menu selection
    By cuffs1845 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-16-2014, 11:54 PM
  5. Replies: 7
    Last Post: 06-06-2013, 02:05 PM
  6. [SOLVED] How do I populate cells (with numbers) from a dropdown (in text) menu in a timesheet?
    By Eddie Elvis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-11-2013, 12:05 AM
  7. [SOLVED] Excel 2007 : new drop down menu based on dropdown menu in previous cell
    By martinpols in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 02:33 AM

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