+ Reply to Thread
Results 1 to 4 of 4

many bits of information:Drop Down List

  1. #1
    Registered User
    Join Date
    12-20-2004
    Posts
    88

    many bits of information:Drop Down List

    I use drop down lists with many bits of information. When I open the lists after they have been used, the list does not go back to the first enty in the list.

    What do I need to do to make the list default to the first enty?

  2. #2
    damorrison
    Guest

    re: many bits of information:Drop Down List

    you can select the cell and press delete,or right click and choose
    clear contents, this will reset it


  3. #3
    Registered User
    Join Date
    12-20-2004
    Posts
    88
    Thank you damorrison, but I don't want to remove data from the list.

    I want to have the list open to the first entry in the list instead of the last entry used. In the list below, if I select orange, the list doesn't default to the beginning (Red). You have to scroll back to Red for the next entry. I'd like to open the list and find the first entry (Red) and Scroll down.

    EXAMPLE:

    List
    red
    blue
    yellow
    green
    black
    white
    orange

  4. #4
    damorrison
    Guest

    re: many bits of information:Drop Down List

    OH,
    if you would clear to cell and then the next time you pulled the cell
    down the list would be at the top, that is what I was talking about,
    Is your list in VBA?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1