Multiple dependent combo boxes

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

  1. anunat

    anunat

    Joined:
    Jun 25, 2012
    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
    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 OUTLOOK 2007 Muliple Boxes Created Prob

    aggieoo7, May 3, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    624
    aggieoo7
    May 3, 2009
  2. skiptotheend

    Access Access 2007 - Using Cascading Combo Boxes to Filter a Query

    skiptotheend, Oct 12, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,132
    skiptotheend
    Oct 12, 2009
  3. missWhite

    Access Access 2003 Check boxes

    missWhite, Jun 17, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    767
    missWhite
    Jun 17, 2010
  4. jwhiz

    Printer / Mouse Setting Dialog boxes

    jwhiz, Oct 4, 2010, in forum: Other Software
    Replies:
    2
    Views:
    483
    jwhiz
    Oct 8, 2010
  5. BeHokie

    Excel Tabbing between boxes in Excel 2007 forms

    BeHokie, Apr 3, 2011, in forum: Microsoft Office
    Replies:
    0
    Views:
    758
    BeHokie
    Apr 3, 2011
  6. A_Barnes
    Replies:
    1
    Views:
    972
    apr pillai
    Jul 23, 2011
  7. dellBoy
    Replies:
    0
    Views:
    655
    dellBoy
    Nov 29, 2011
  8. Laconic

    Synchronizing Combo boxes

    Laconic, Mar 22, 2013, in forum: Other Software
    Replies:
    0
    Views:
    732
    Laconic
    Mar 22, 2013
Loading...