Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set excel pulldown list starting value to current cell valu
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set excel pulldown list starting value to current cellvalu
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. Nolo44 wrote: 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 Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
link cell in excel to current date | Excel Discussion (Misc queries) | |||
auto updating list | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
can excel choose a name from a list when I am typing in a cell | Excel Worksheet Functions |