Hi again Andy,

The formula should be written in the box of the Data Validation--List,
not at the Formula.

Thankyou,

Shail


I see. It wasn't clear that =IF(A1="",MyList,"") should be the Data
Validation formula (with "Custom" for "Allow", presumably). But it still
doesn't work at all well that way -- with A1 blank, there's no dropdown
*and* it lets me enter 6. Which kind of defeats the object. :(