How to set excel pulldown list starting value to current cell valu

[Guest]

Excel 2003 spreadsheet two data validation type listbox pulldowns using named
ranges for the list. One has simply "Task 0" through "Task 4" as choice. The
other has a series of pay period ending dates 4 week intervals for the next
several years.

The listbox pulldown with Task 0 - Task 4 will show as starting point in the
pulldown the current task selected in the listbox cell. This is what I want
to occur.

However, the listbox date pullown always starts at the beginning of the date
range, not the currently selected date.

I do not know why the two act differently and want both pulldowns to start
with the cell value.

Both listboxes are set up the same, using excel's standard data validation
tools, not VBA.

 

[Debra Dalgleish]

Format the dates in the dropdown list the same as the date is formatted
in the cell that contains the data validation. Then, the list should
open at the selected date.