Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Drop Down List - Always Show
Hi,
I have a data validation drop-down list on a cell, and would like the drop down arrow to always show, instead of just when you place focus on that particular cell. Any ideas? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation Drop Down List - Always Show
combo boxfrom the forms or control toolbox.Both are a little more difficult
to set up than the DV list forms combo box Combo box A drop-down list box. The item that is selected in the list box appears in the text box. Combo box properties Input range Reference to the range containing the values to display in the drop-down list. Cell link Returns the number of the item that's selected in the combo box (the first item in the list is 1). You can use this number in a formula or macro to return the actual item from the input range. For example, if a combo box is linked to cell C1 and the input range for the list is D10:D15, the following formula returns the value from range D10:D15 based on the selection in the list: =INDEX(D10:D15,C1) Drop-down lines Specifies the number of lines to display in the drop-down list. 3D shading Displays the combo box with a 3-dimensional shaded effect. you can use Choose(c1,d10,d11,d12,d13,d14,d15) as well -- paul remove nospam for email addy! "Louise" wrote: Hi, I have a data validation drop-down list on a cell, and would like the drop down arrow to always show, instead of just when you place focus on that particular cell. Any ideas? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing Drop Down list -Data Validation | Excel Discussion (Misc queries) | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Symbols in Data Validation List | Excel Worksheet Functions | |||
data validation list drop down text format too small | Excel Worksheet Functions |