auto dropdown menu
 

Hi, Is there a way to drop down the menu as soon as the cell is
activated? right now my menus are through data valadation, if I have
to use another way that will be ok! in the long run, it will pay off...
Dave

auto dropdown menu
 

If you select the cell and hit alt-downarrow, you'll see the list.

So you may be able to do something like:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Me.Range("c1,e4")) Is Nothing Then Exit Sub

Application.SendKeys "%{down}"
End Sub

I just checked C1 and E4, but you can change that to whatever cells have
dropdown validation.

damorrison wrote:

Hi, Is there a way to drop down the menu as soon as the cell is
activated? right now my menus are through data valadation, if I have
to use another way that will be ok! in the long run, it will pay off...
Dave

--

Dave Peterson