+ Reply to Thread
Results 1 to 8 of 8

List for for same dropdown

  1. 02-21-2017, 04:23 AM #1
    iamarush
    iamarush is offline
    Registered User
    Join Date
    02-08-2017
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    8

    Thumbs up List for for same dropdown

    Hi,

    I have 1 combo box and 1 list box, the list box should populate the values for only those for which the selection done in combo box one, kindly suggest how do i do this please via VBA code in VBA form (.i.e. If i select Hyundai in combo box only Hyundai brands should appear in list box.)
    Last edited by iamarush; 02-22-2017 at 03:25 AM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 02-21-2017, 04:28 AM #2
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: List for for same dropdown

    Would be better to upload a sample workbook with sufficient enough volume of data to test the solution.
    Also add your desired results manually so that your requirement could be understood.
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  3. 02-21-2017, 04:29 AM #3
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: List for for same dropdown

    http://www.excelforum.com/excel-prog...-dropdown.html
    this is the duplicate thread.Admins please delete.
    Reply With QuoteRegister To Reply
  4. 02-21-2017, 05:30 AM #4
    iamarush
    iamarush is offline
    Registered User
    Join Date
    02-08-2017
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    8

    Re: List for for same dropdown

    Hi Imran,

    I am here by attaching the file here i have given you few columns based this i can create further column,


    My requirement is, i will be selecting the location If i select Bangalore in location updater name should appear which are actually for bangalore based on this the model ID should come only for that person name, i will select Bangalore from combobox1 and Arush from combobox 2 only Arush's ID should apprear in list1box2,

    thanks for your helptest User Form.xlsm
    Reply With QuoteRegister To Reply
  5. 02-21-2017, 09:43 AM #5
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: List for for same dropdown

    What I understood here is the solution for that

    Please Login or Register  to view this content.
    See attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-21-2017, 09:51 AM #6
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: List for for same dropdown

    Hi Arush thanks for the rep
    And if the solution really helped you, please mark your thread as solved .
    Reply With QuoteRegister To Reply
  7. 02-22-2017, 03:21 AM #7
    iamarush
    iamarush is offline
    Registered User
    Join Date
    02-08-2017
    Location
    Mumbai
    MS-Off Ver
    2010
    Posts
    8

    Re: List for for same dropdown

    Thanks Imran This Solves my query
    Reply With QuoteRegister To Reply
  8. 02-22-2017, 05:14 AM #8
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: List for for same dropdown

    You are welcome Arush.Glad to have helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need cell C to either produce dropdown list 1, dropdown list 2, or text value "yes" based
    By btatc620 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2016, 04:26 PM
  2. Combine Combo Dropdown list box & Validation Dropdown list box?
    By DianneDB in forum Excel General
    Replies: 0
    Last Post: 08-22-2012, 03:52 PM
  3. Dropdown list effects multiple dropdown list
    By pvaldez in forum Excel General
    Replies: 1
    Last Post: 05-07-2010, 02:12 PM
  4. Excel 2007 : How to add items to a dropdown list dynamically by typing in the dropdown list cell?
    By incisivekeith in forum Excel General
    Replies: 21
    Last Post: 12-02-2009, 03:27 PM
  5. Date dropdown list and a Time dropdown list in outlook
    By L_ter in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 03-30-2009, 02:33 AM
  6. [SOLVED] result of selecting from the dropdown list should be a dropdown list
    By No News in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-05-2006, 11:15 AM
  7. [SOLVED] result of selecting from the dropdown list should be a dropdown list
    By No News in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2006, 05:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1