Excel Validation

[toccata]

Is there a method, function, setting to set a default value in a dropdown?

 

[SkipVought]

Hi,

What kind of control...
[tt]
Control Toolbox
Forms
Data Validation List
[/tt]
???

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[toccata]

Data validatio list

 

[SkipVought]

Assign the default value to the CELL or RANGE containg the Data Validation.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[SkipVought]

You'll probably want to record a macro to do this.

At what event do you want the default value assigned?

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[toccata]

The event generating the default value is the cell to the left not null or <>"". The list contains 12 elements.

 

[SkipVought]

What you described is not an event. What you described is a criteria. Opening the workbook, or activating a worksheet or calculation is an event.

What is the range that contains the Data Validation list? Is there a contiguous range of data in any column?

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}