+ Reply to Thread
Results 1 to 2 of 2

ComboBox to populate Listbox and 2nd Combobox based on 1st combobox dropdown choice

  1. #1
    Registered User
    Join Date
    11-25-2015
    Location
    Manitoba
    MS-Off Ver
    2016
    Posts
    36

    ComboBox to populate Listbox and 2nd Combobox based on 1st combobox dropdown choice

    Hello all,

    First I wish to thank Mehmetcik for all his help and patience with me as I familiarize myself with requests, forums and vba in excel with Userforms.
    With Mehmetcik's help I updated his great code given and made it more detailed to my needs within the userform
    My problem now is I have a few comboboxes and listbox and need to populate the listbox with with data that associates directly to the combobox numer chosen. I am also looking at when the number chosen from the combobox once it fills the listbox I am trying to see if it can pull the data for all agents that have that number beside their name and place in the next combobox.

    combobox1 is named cbMU and that drives results in listbox named lbMSN with the skills for that MU. Plus the cbMU needs to call the data for all agents into the combobox named cbData.
    All data is pulled from GtoICheck and the Audit date Tracker is for tracking from the lower section you may see when opening and viewing the userform

    All agent names are in col A
    the MU they are placed in is in col C
    skill name each agent has is col E
    G skill col F and IX skill col G and finally name check is col H
    Column R, S, T have the MU, Skill name, and level

    example: cbMU drop down chosen say # 100 from list then any agent in 100 from range A;H show in cbData (have to not include blank columns in cbData but not delete in worksheet) and also populate lbMSN with the skill names and levels only (not the MU #) for that particular number chosen.

    I tried adopting a few codes from sites and forums and none seem to fit what I am looking for considering the columns and rows are somewhat spaced and unorganized but they have to stay that way as I removed confidential info from the workbook so it becomes usable for assistance.
    I also have AE:BB which has the MU number and skills under each MU in attempts to try and make it work but to no avail.

    Here is what I managed to get which fills the lbMSN but even the results are not correct
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    the remaining UserForm code I did not include as it relates to a previous problem that as mentioned I had help for and adapted the code to suit my requirements.

    Any help or guidance is greatly appreciated as I continue to learn and develop as I find building things like a userform and applying vba code is exciting and yet a hard challenge that I like.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-25-2015
    Location
    Manitoba
    MS-Off Ver
    2016
    Posts
    36

    Re: ComboBox to populate Listbox and 2nd Combobox based on 1st combobox dropdown choice

    Hello everyone

    Just to let everyone know I revised my code and got this working for the Listbox

    The above code I replaced with the following should anyone be interested or come across a similar situation.

    Please Login or Register  to view this content.
    I continued the code till all the Mu list was completed and tested it and it worked to what I needed.

    I am impressed I was able to solve my own problem!
    Hope this helps someone should they need.

    Closing the post as solved.

+ 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] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  2. [SOLVED] How do I populate a specific range in one ComboBox based of selection of another ComboBox?
    By gmr4evr1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-04-2015, 04:32 PM
  3. Userform Combobox to populate based on selection in another combobox
    By Excelnoub in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2014, 03:34 PM
  4. populate 4 combobox based on dependant combobox
    By roninn75 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-06-2013, 06:09 AM
  5. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  6. Replies: 2
    Last Post: 12-07-2012, 02:10 AM
  7. Way to populate combobox rowsource based on previous combobox value
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2012, 12:50 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