drop down arrow
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: drop down arrow

  1. #1
    Guest

    Default

     
    when a cell with a list box is selected
    an arrow appears next to the cell. Is it
    possible to have this arrow stay on the screen even when the cell is not selected.
    I want the user to know to look there.

    thanks

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What you have discribed is probably the
    data validation box....it's not possible
    for this to remain visible.

    couple of options though if you do want a
    combobox type visible;
    1) either use a combobox avail via
    a) Forms combars or
    b) Control toolbox
    2) Format the cell to look like a data
    selection area.

    Ivan

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-14 23:16, Ivan F Moala wrote:
    What you have discribed is probably the
    data validation box....it's not possible
    for this to remain visible.

    couple of options though if you do want a
    combobox type visible;
    1) either use a combobox avail via
    a) Forms combars or
    b) Control toolbox
    2) Format the cell to look like a data
    selection area.

    Ivan
    Thanks Ivan.

    The look of the combo box is fine. But how do I make it work like the list box? Easy?

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Thanks Ivan.

    The look of the combo box is fine. But how do I make it work like the list box? Easy?
    For combobox from Control toolbox
    Right click on the object and view it's properties. (1st you must be in design mode)

    For combobox from Forms control
    Right click and select format control
    View your options there.


    Post for further help


    Ivan

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 13:42, Ivan F Moala wrote:

    Thanks Ivan.

    The look of the combo box is fine. But how do I make it work like the list box? Easy?
    For combobox from Control toolbox
    Right click on the object and view it's properties. (1st you must be in design mode)

    For combobox from Forms control
    Right click and select format control
    View your options there.


    Post for further help


    Ivan
    Thanks again but still trouble. Options in either place don't give me what I need. As you mentioned earlier, from right click, to properties and puting in the linked cell and range is close, but in linked cell I can only get one option and it can not put drop down.

  6. #6
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Name your list range for your dropdown list. Then use the name range for the criteria. Else use column notation like: $AA:$AA for all of column "AA" as the items in your dropdown list. JSW

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com