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?
Re: cascading combo boxes and unique values
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mehmet in forum Excel General
Last Post: 02-23-2013, 07:57 AM
By ranjaniramajuam in forum Excel - New Users/Basics
Last Post: 05-22-2008, 07:46 AM
By dkinnz in forum Excel Programming / VBA / Macros
Last Post: 01-05-2007, 05:37 PM
By email@example.com in forum Excel Programming / VBA / Macros
Last Post: 02-10-2006, 05:20 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1