1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Drop Down Box

Discussion in 'Business Applications' started by JoeHart, Sep 24, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. JoeHart

    JoeHart Thread Starter

    Joined:
    Aug 17, 2008
    Messages:
    125
    This is a simple question for most of you. I am trying to create a drop down box for Column A. There are 6 different choices. Line, Substation, Generator, General, Tie Line and All Lines. Since some of these involve 2 words I understand it gets a little more complicated. Also All lines is both Tie Line and Line. I think I have to use a look up table, but not sure how.
    Thanks,
    Joe
     

    Attached Files:

  2. Nic Cunliffe

    Nic Cunliffe

    Joined:
    Sep 18, 2008
    Messages:
    22
    Try this using excel list. Select your data that you want to be in the drop down and then data list (screen scot enclosed also.

    You can also add new records to the list (and dropdown) box by just typing in the bottom cell in the list.

    Regards - Nic
     

    Attached Files:

  3. JoeHart

    JoeHart Thread Starter

    Joined:
    Aug 17, 2008
    Messages:
    125
    That's perfect, except how do I select all lines. This would equal line and Tie Lines. I know how I do it with the custom feature but is there a way to just select all lines.
     
  4. Nic Cunliffe

    Nic Cunliffe

    Joined:
    Sep 18, 2008
    Messages:
    22
    The most simple way would be to merge your labels so instead of having

    Tie Lines
    Lines

    Change them all to:

    Lines/Tie Lines as a combined category. Alternatively, it is possible to write a macro to set the custom filter to = "lines" and "tie lines" and assign this to a button but this is a little more complex.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/752998

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice