+ Reply to Thread
Results 1 to 8 of 8

Make combobox list options dependant on selection in another combobox within a userform

  1. #1
    Registered User
    Join Date
    09-17-2013
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Make combobox list options dependant on selection in another combobox within a userform

    Hi,

    I have an Excel workbook with a front sheet containing a Userform named "Package_Size".
    "Package_Size" has two Comboboxes: "Commodity_Selection" and "Size_Selection"
    I need the dropdown list options for the "Size_Selection" to be dependant on the option chosen in "Commodity_Selection".

    The options for "Commodity_Selection" are set in 'UserForm Initialize':

    Please Login or Register  to view this content.
    The options for "Size_Selection" are stored in a sheet named "Pick Lists". An example of the relevant workbook sheets is attached below.

    Example Workbook for Forum.xlsm

    I have tried various solutions involving 'If' and 'Select Case', but none have worked, and I am also very new to using VBA.
    Please let me know if you require any more information.

    Many thanks in advance for any help!
    Last edited by Vladimir_Dobvchenko; 09-18-2013 at 08:00 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    To Package_Size code module.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    Try your sheet modified Code Attached .
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-17-2013
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    Thank you very much for the solution jindon, my UserForm now operates exactly as I needed.
    Please could you provide a brief explanation of how the code works, so that I can understand?
    Thanks again!

  5. #5
    Registered User
    Join Date
    09-17-2013
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    Thank you very much for your solution MickG.
    You've both been very helpful.

  6. #6
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    You're Welcome
    Regrds Mick

  7. #7
    Registered User
    Join Date
    10-07-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    so helpfully...thanks

  8. #8
    Registered User
    Join Date
    10-07-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Make combobox list options dependant on selection in another combobox within a userfor

    so helpfully...thanks

+ 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] How do I make a selection from a combobox on my VBA userform populate a textbox?
    By ChristianMba in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-16-2012, 01:08 PM
  2. I need to make a dependant combobox
    By grizzlypete44 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-02-2011, 02:55 PM
  3. Userform Dependant Combobox
    By bojum01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2011, 07:52 PM
  4. Userform Dependant Combobox - can't get cbo2 to show list based on cbo1 inpt
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2011, 07:18 AM
  5. Dependant Combobox in userform
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2007, 03:14 AM

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