View Single Post
  #3   Report Post  
Andy Brown
 
Posts: n/a
Default

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