Results 1 to 8 of 8

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

Threaded View

  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':

    Private Sub UserForm_Initialize()
        Commodity_Selection.List = Array("Externals", "Spec Fabs", "Units", "Electronics", "Nacelles")
    End Sub
    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.

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