In checking existing discussions I have learned that dropdown lists (created
through built-in data validation) cannot use autocomplete procedures. What I
am seeking now is whether there is any way to cause a cell's dropdown list to
actually drop down upon entry into the cell, without having to click on the
dropdown arrow?

I am using Excel 2003 but am also interested in whether this can be
accomplished in Excel 2007.