| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown list
Hi all -
After creating a dropdown box, is there a way to make the dropdown arrow always visible? The user may not know there is any info available in the box until they highlight it. I want to create a list of items so that when a user clicks the dropdown box or arrow, they will see the inventory available for that area. This will be just a list to view available items in the list, they will not need to select any of these items. I am creating cells for different locations and each dropdown list will reflect what is available in that location. Thanks! Regards, Duane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown list
I assume you are using Data Validation as the drop-down; look at a ListBox on
the "Forms" toolbar which does have the arrow visible. You can still refer to the same data list. HTH "Need help with dropdown lists" wrote: Hi all - After creating a dropdown box, is there a way to make the dropdown arrow always visible? The user may not know there is any info available in the box until they highlight it. I want to create a list of items so that when a user clicks the dropdown box or arrow, they will see the inventory available for that area. This will be just a list to view available items in the list, they will not need to select any of these items. I am creating cells for different locations and each dropdown list will reflect what is available in that location. Thanks! Regards, Duane |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dropdown list
Thanks Toppers! That will work!
"Toppers" wrote: I assume you are using Data Validation as the drop-down; look at a ListBox on the "Forms" toolbar which does have the arrow visible. You can still refer to the same data list. HTH "Need help with dropdown lists" wrote: Hi all - After creating a dropdown box, is there a way to make the dropdown arrow always visible? The user may not know there is any info available in the box until they highlight it. I want to create a list of items so that when a user clicks the dropdown box or arrow, they will see the inventory available for that area. This will be just a list to view available items in the list, they will not need to select any of these items. I am creating cells for different locations and each dropdown list will reflect what is available in that location. Thanks! Regards, Duane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preventing manual entry in dropdown list ... possible? | Excel Discussion (Misc queries) | |||
| How to Change List Based on Value Chosen in Another List | Excel Worksheet Functions | |||
| Entering data from dropdown list | Excel Discussion (Misc queries) | |||
| HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
| How to show dropdown list from another workbook without running it | Excel Discussion (Misc queries) | |||
Linear Mode
