Multiple dependent combo boxes

Discussion in 'General Software' started by anunat, Jun 29, 2012.

  1. anunat

    anunat

    Joined:
    Jun 25, 2012
    Messages:
    5
    Likes Received:
    0
    Hi

    I have a date field. I have two combo boxes. One for year and One for month.

    I have already written code for the year combo box to show only the unique years represented in the date field.

    I am now trying to make the month combo box show only months present in the year selected. Also the months need to be sorted from latest to oldest in each year.

    For example:

    Datefield
    6/1/2012
    5/1/2012
    6/1/2011
    4/1/2012
    3/1/2011


    Year combo box should show only 2011 and 2012.

    If user selects 2011 for year then the month combo box should show June, March in that order

    If user selects 2012 for year then the month combo box should show June, May, April in that order
     
    anunat, Jun 29, 2012
    #1
    1. Advertisements

  2. anunat

    pjmorris

    Joined:
    Aug 1, 2012
    Messages:
    16
    Likes Received:
    0
    Have you tried using Data Validation? You need to create dynamic named ranges and use these as the source for the Data Validation, the drop down list in each field will then have the information you want. I can't remember exactly where I found the advice, but this link http://www.get-digital-help.com/201...s-containing-unique-distinct-values-in-excel/ should help.

    Your requirements are entirely achievable.

    Regards

    Peter
     
    pjmorris, Aug 1, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. aggieoo7

    OUTLOOK 2007 Muliple Boxes Created Prob

    aggieoo7, May 3, 2009, in forum: General Software
    Replies:
    0
    Views:
    527
    aggieoo7
    May 3, 2009
  2. skiptotheend
    Replies:
    0
    Views:
    935
    skiptotheend
    Oct 12, 2009
  3. A_Barnes
    Replies:
    1
    Views:
    735
    apr pillai
    Jul 23, 2011
  4. dellBoy
    Replies:
    0
    Views:
    502
    dellBoy
    Nov 29, 2011
  5. Laconic

    Synchronizing Combo boxes

    Laconic, Mar 22, 2013, in forum: General Software
    Replies:
    0
    Views:
    610
    Laconic
    Mar 22, 2013
Loading...

Share This Page