| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default Value in a list box
I have a list box in cell A8. It's a list box created using data validation.
The values are all dates. How do I get it to populate a default date when opening the file? The list of values is dates for every Monday so I want it to default to the current week's Monday. For example if today was 9/12/07 I would want it to be 9/10/07 when the file is opened. How would I make this happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default to Top of Drop Down List | Excel Worksheet Functions | |||
| How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
| Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
| List box - setting default selection | Excel Discussion (Misc queries) | |||
| drop down list default | Excel Worksheet Functions | |||
Threaded Mode
