Showing Lists in active cell

  • Thread starter Thread starter Spuds Glorious Spuds
  • Start date Start date
S

Spuds Glorious Spuds

Anyone have a suggestion how I could get a worksheet to only show a List for
an active cell without having to sellect the drop down arrow.

Thanks
 
Hi,

Which list are you talking about? The AutoComplete list, a Data Validation
List, an AutoFilter list, a combo box List?

For some list Alt+Down Arrow works, or F4.
 
Thanks Shane,

I'll try to be more clear - I am using data in columns BE : DH, which can be
seen by the user via a validation list in Column U or V

The data content differs for every active row in the sheet (which updates
continuously thorugh the day)

I was just wondering if the user could see the contents of the of the
validation list by activating the cell rather than selecting the "drop down
button" in the cell

Cheers
 
Hi,

For a data validation list you can use the Alt+Down arrow or you could add
the following code to the sheet object:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim insect As Range
Set insect = Intersect(Target, Range("E1:E12"))
If Not insect Is Nothing Then
SendKeys "%{Down}"
End If
End Sub

change the range to match yours.

Cheers,
Shane Devenshire
 
Hello Shane,

This code didn't seem to work for me. I wasn't quite sure exactly where to
put the code though so that may have been the problem. If you have
additional instructions as to where I am to copy and paste this code and
re-adjusting the range, can you please explain?

I need pretty much the same type of information. I can use validate, but
they don't want any arrows on the sheet they would just like all options
popping up simply by clicking the cell in the current row. They want the
list available for each row, and several of these drop down lists across the
sheet for different headings.

I know nothing about the Visual Basic Editor.
 
Back
Top