Results 1 to 3 of 3

Thread: Is there a feature like Always show in Data Validation Drop Down List

  1. #1
    Join Date
    Feb 2012
    Posts
    8

    Is there a feature like Always show in Data Validation Drop Down List

    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.

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: Is there a feature like Always show in Data Validation Drop Down List

    Combo box from 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. In Combo box properties the 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 D1015, the following formula returns the value from range D1015
    based on the selection in the list: =INDEX(D1015,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.

  3. #3
    Join Date
    Jul 2011
    Posts
    434

    Re: Is there a feature like Always show in Data Validation Drop Down List

    The drop down list appear only if you try to type something in it. I tried looking out for detail in the properties of drop down list but that does not showed up any settings for this.

Similar Threads

  1. How to use table column as data validation list
    By connoisseur in forum MS Office Support
    Replies: 2
    Last Post: 13-01-2012, 06:10 PM
  2. Multiple columns Data Validation in drop down
    By McKenzie! in forum Software Development
    Replies: 6
    Last Post: 16-07-2011, 10:52 AM
  3. What is the Drag and Drop Feature to Photos in Facebook
    By Bindoo in forum Technology & Internet
    Replies: 3
    Last Post: 18-11-2010, 09:44 PM
  4. Drag and drop feature in Gmail labeling
    By Trio in forum Technology & Internet
    Replies: 3
    Last Post: 02-07-2009, 11:44 PM
  5. Validation list: selecting a value, display another
    By CodGuru in forum Software Development
    Replies: 3
    Last Post: 27-04-2009, 12:08 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,430,273.37112 seconds with 17 queries