DropDown
 

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

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