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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks