Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Default
How can I specify the default text in a drop down menu until a selection is
made? Even better, can I reset the default display text in a drop down if the validated data table changes? (The drop down pulls from a data table that changes). I basically I want the text in the drop down to read "Select customer here" Any help would be appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Default
See Debra Dalgleish's site for a sample workbook that might be what you
need. http://www.contextures.on.ca/excelfiles.html#DataVal DV0041 - Reset Data Validation Cells -- Macro to clear data valiation cells, and if cell has a data validation list, select the first item from the list. DataValReset.zip 10 kb 21-May-06 Or this one.......... DV0019 - Default to First Value-- Data validation limits values that can be entered; event macro enters the default value for the selected option. DataValYesNoRates.zip 8 kb Gord Dibben MS Excel MVP On Fri, 5 Sep 2008 09:50:01 -0700, Bliss wrote: How can I specify the default text in a drop down menu until a selection is made? Even better, can I reset the default display text in a drop down if the validated data table changes? (The drop down pulls from a data table that changes). I basically I want the text in the drop down to read "Select customer here" Any help would be appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default to Top of Drop Down List | Excel Worksheet Functions | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) | |||
How do I set cell drag and drop to be on as a default | Excel Discussion (Misc queries) | |||
Drag&Drop / Cut &Paste default perameters | Excel Discussion (Misc queries) | |||
drop down list default | Excel Worksheet Functions |