Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Lists in active cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Lists in active cell
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 Devenshire "Spuds Glorious Spuds" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Lists in active cell
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 "ShaneDevenshire" wrote: 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 Devenshire "Spuds Glorious Spuds" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Lists in active cell
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 "Spuds Glorious Spuds" wrote: 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 "ShaneDevenshire" wrote: 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 Devenshire "Spuds Glorious Spuds" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing Lists in active cell
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. "Shane Devenshire" wrote: 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 "Spuds Glorious Spuds" wrote: 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 "ShaneDevenshire" wrote: 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 Devenshire "Spuds Glorious Spuds" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation look-up lists showing in 8 point, too small read easily | Excel Worksheet Functions | |||
Data Validation: How do I hide border of ACTIVE lists? | Excel Discussion (Misc queries) | |||
set the background color of the current cell(active cell) | New Users to Excel | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |