Listbox referencing

[excelmacro]

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

 

[Ricky Morris]

Set up a link to the other file in your current file, then attached the list box to the linked range.

 

[excelmacro]

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.

 

[itsmewhoelse]

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

http://www.microsoft.com/mac/excelx/excelx_main.asp?embfpath=howtox&embfname=xl_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!

 

[excelmacro]

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