Drop Down Default

B

Bliss

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!
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Select drop down menu option using libre-calc macro 0
How To Clear Previous Selection From a Drop Down 2
Drop down list 1
Drop-Down List 3
Drop Down Calendar in Excel with a Default Value 1
Best method to populate cell based upon drop down list selection 4
Drop Down Menu 4

Top