Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: relating lists and cells

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Isle of Man
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I relate one list to another?

    I have 2 lists on seperate pages that I want to display the same information.

    Also... Is there any way to make a combobox display all the entries from a list (so it would be relational to that list and if the list changed, so did the combobox)

    [ This Message was edited by: curph on 2002-04-05 04:07 ]

    [ This Message was edited by: curph on 2002-04-05 04:12 ]

    [ This Message was edited by: curph on 2002-04-05 04:21 ]

    [ This Message was edited by: curph on 2002-04-05 04:26 ]

    [ This Message was edited by: curph on 2002-04-05 04:30 ]

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't know quite how to do the first part except to copy, then edit and paste special-paste link.

    Put your values in a column by themselves, no heading. Select the whole column, and hit Insert-Name-Define, call it MyLookup or something like that.

    To make the *combobox*, go to that cell, hit Data-Validation, choose List. Type =MyLookup as the range.
    ~Anne Troy

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Isle of Man
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, but does that method work for a combobox in a userform? Will i need to write a macro?

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No, that method works WITHOUT code/combobox/userform.

    Sorry. I don't know how to do the userform stuff.


    ~Anne Troy

Some videos you may like

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
  •