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
|