+ Reply to Thread
Results 1 to 2 of 2

controlling a form drop down based on selection of another drop down

  1. #1
    Registered User
    Join Date

    controlling a form drop down based on selection of another drop down

    I've got a form that has a selection of drop downs - I'd like one of the drop down later on in the form to be controlled by what a user selects in the first drop down - e.g. the first drop down has A, B, C, D, E to select from - if they select A I'd like the later drop down to show certain list, if they select B I'd like it to show a different list and so on. Is this possible? Many, many thanks as ever!

  2. #2
    Forum Contributor colofnature's Avatar
    Join Date
    MS-Off Ver
    If you have a dynamic range in the workbook, whose size relates to the value of the first combobox
    e.g. on Sheet1
    column A|column B
    A Ai
    A Aii
    A Aiii
    B Bi
    B Bii
    C Ci
    C Cii
    C Ciii
    etc whatever...

    and C1 is linked to CombBox1.ControlSource
    with a named range "MyRange"

    Then put something like this in the the _enter event of ComboBox2 or _exit event of ComboBox1

    if thisworkbook.sheets("Sheet1").range("C1").value<>empty then
    for each c in thisworkbook.sheets("Sheet1").range("MyRange")
    ComboBox2.additem (c.value)

    You'll probably need to tweak it a little...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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