I tryied this but it did not work I'm sure I've done something wrong. I
pasted the formula in visual basic and saved would that be it? Help Please

"Andy Brown" wrote:

Help please excel; when I select a cell that has a drop down box I want it
to
open

Try some code in the worksheet module (rightclick the sheet tab & "View
Code"):

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address < "$B$2" Then Exit Sub
SendKeys "%{DOWN}"
End Sub