Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pop-up lists (Excel97 with Win98SE)

    This is probably an "old" question but I cannot find any references to it. Maybe I have the wrong name for what I want.
    I have a wide spread sheet (custom built personal cash book) and need to page across to find the name of the category I want to use for an entry in a column on the first page. That is I enter date, description, amount and category on the first page but the categories spread over a large number of columns and I don't want to make a pen-and-paper list of them.
    I want to be able to bring up a list of my (customised) categories when I am in the column on the first page.
    I have seen instructions on how to do it years ago but now cannot find anything.
    Thanks, Ken <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up lists (Excel97 with Win98SE)

    Select the cells where you want the list, and then select Validation from the Data menu. In the allow box select List, and then fill in the source to point to your list of categories.
    Legare Coleman

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Pop-up lists (Excel97 with Win98SE)

    I interpreted your question slightly differently than Legare. So I will suggest Freezing your first column in position, this way when you scroll to the right your categories column will remain visible.
    To do this:
    If you want to freeze column A in position, click into cell B1- it always freezes the column to the left of the active cell.
    If you want to freeze column A and Row 1 in position, click into cell B2 - it always freezes the column to the left and the row above the active cell.
    Choose the Window, Freeze Panes menu. This will remain frozen until you unfreeze the panes.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up lists (Excel97 with Win98SE)

    Thanks Legare (and Catharine). Your suggestion is the sort of thing I thought I wanted. However I cannot make it do what I want. I suspect I really want some combination of LookUp and Validation Lists!
    When I am in cell D42 (say) I need to put a value which is a column name i.e. H or K or Z or whatever. What I need to know though, is what I have used each column for. For instance column F is for food expenses; column G is for family related expenses; column H is for car and other transport expenses. What I want (if it is possible) is to be in D42, call up a list showing the correlation of F with food, G with family etc and select from that list just the column name - F or H or whatever.
    Is this something I can do or do I need to write a macro for it? (It would be my first Excel macro athough I used to write Lotus 123 macros years ago.)
    Thanks again,
    Ken

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up lists (Excel97 with Win98SE)

    There are a couple of things that you could do:

    1- You could use the worksheet selection change event rortine to display a user form when you enter a cell in the range where you want these column letters. That routine would display a user form with a list box that could be used to select a category, and the code would return the corresponding letter to the cell.

    2- You could use two columns. You could use the techineque I described previously to select a category, and a HLOOKUP formula in the second coulmn to return the column letter that corresponds to the category.
    Legare Coleman

Posting Permissions

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