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!