+ Reply to Thread
Results 1 to 2 of 2

cascading combo boxes and unique values

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    58

    cascading combo boxes and unique values

    hello everybody, got two questions

    1. i have a weird dilemma in respect to cascade combo boxes. What I am trying to do is create cascading combo boxes where once a document is selected, the next cascade combo box will be populated with data from the Date of Doc column. as date of doc date is selected, the third combo box would be populated with dates from the Date of Input. I have successfully created cascading combo boxes with 2 dependent boxes before(i was able to create other cascading relationships with other data in the table) , but for some odd reason the third combo box will not populate with data from the date of inputcolumn.

    2. the second question that i have is in respect to the dependent/cascaded combo boxes, how can we make them unique values? for example, in my date of doc column, there are really only 4 different dates. but once a document is selected, looking in the combo box for date of doc, there will be a significant number of entries. how to make these entries limited to the 4 dates listed?


    thanks
    Attached Files Attached Files

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

    Re: cascading combo boxes and unique values

    Try the attached
    Attached Files Attached Files

+ 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. cascading combo boxes
    By mehmet in forum Excel General
    Replies: 18
    Last Post: 02-23-2013, 07:57 AM
  2. cascading combo boxes
    By ranjaniramajuam in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 05-22-2008, 07:46 AM
  3. cascading combo boxes
    By dkinnz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2007, 05:37 PM
  4. Cascading Combo Boxes
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2006, 05:20 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