Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Listbox referencing

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Alberta, Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I reference my listbox to cells that are in a different file?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    363
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Set up a link to the other file in your current file, then attached the list box to the linked range.
    It's never too late to learn something new.

    Ricky

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Alberta, Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I do this? I've never dealt with listboxes before.

    my other file is in C:datamaydata.xls and the sheet is datasheet2002. I want the list box to contain all the names column A.

  4. #4
    New Member
    Join Date
    Apr 2002
    Location
    Atlanta,Ga
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was having the same problem. Heres how I got around it.
    First I found this article:

    http://www.microsoft.com/mac/excelx/..._listboxes.asp

    Then I copied my "data" worksheet to a new worksheet in the workbook I wanted the list box in. I renamed it Data.Then I followed the instructions in the article, and it works great! Every time you add to your "data" list, they appear in the list box. For some reason (stupidity, I guess) I could not make it work when it was in a different workbook, that's why I copied it to the new workbook.
    Good Luck!

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Alberta, Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This would be great, but I'm not using mac. Under my format menu, I don't have a control option. the only things i can see that are closely related is under the item properties where it lets you put in controlsource and rowsource. neither of these let you refer to cells in another file (at least as far as i can tell).

    EDIT: sorry bout that. it works if doing it from the excel window. i was trying to do it through VBA, and they are somewhat similar, but not completely.

    [ This Message was edited by: excelmacro on 2002-04-24 12:44 ]

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
  •