DropDown
Steven, you could use some code to do it, right click on worksheet view code
paste this in the window that opens
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Me.Range("A1")) Is Nothing Then Exit Sub
'***Change to your cell****
Application.SendKeys "%{down}"
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Steven" wrote in message
...
I have a cell with Validation. The Validation is based on a range. Is
there
a way that when you click on that cell it automatically drops down so you
can
see the items without having to click the arrow.
Thank you,
Steven
|