Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare rowsources
Last question;
I have two comboboxes. The first has a rowsource from a named range of dates. I want to populate the second rowsource when a date is chosen in the first one. I only want to show dates greater than the first in the second. I am assuming I want to use a for each to compare values, but I am stumped: Dim CheckDate as ? Combobox2.rowsource="" For Each CheckDate in (namedrange) if CheckDate Combobox1.value then combobox2.additem CheckDate end if next CheckDate Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare rowsources
Dim CheckDate as Range
Combobox2.rowsource="" Combobox2.Clear For Each CheckDate in Range("DateRange") If CheckDate.Value2 cLng(Combobox1.value) then combobox2.additem format(CheckDate.Value,"m/d/yyyy") end if next CheckDate -- Regards, Tom Ogilvy "King" wrote in message news:3EBib.755712$Ho3.193248@sccrnsc03... Last question; I have two comboboxes. The first has a rowsource from a named range of dates. I want to populate the second rowsource when a date is chosen in the first one. I only want to show dates greater than the first in the second. I am assuming I want to use a for each to compare values, but I am stumped: Dim CheckDate as ? Combobox2.rowsource="" For Each CheckDate in (namedrange) if CheckDate Combobox1.value then combobox2.additem CheckDate end if next CheckDate Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMPARE Add-in | Excel Discussion (Misc queries) | |||
Compare | Excel Worksheet Functions | |||
Compare | Excel Worksheet Functions | |||
How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
compare data from one column with another and compare result to yet another | Excel Programming |