Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
Dropdown box display only data dependent on another dropdown box? | Excel Worksheet Functions | |||
Dropdown List within a dropdown | Excel Worksheet Functions | |||
populating a dropdown based on choice from a previous dropdown | Excel Programming | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) |