+ 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
    2013
    Posts
    131

    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
    Excel 2007
    Posts
    4,787

    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
    2013
    Posts
    131

    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)

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