Listbox referencing

excelmacro · Apr 24th, 2002, 08:12 AM

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

Ricky Morris · Apr 24th, 2002, 09:23 AM

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

excelmacro · Apr 24th, 2002, 09:50 AM

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 · Apr 24th, 2002, 10:21 AM

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!

excelmacro · Apr 24th, 2002, 11:29 AM

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 ]

Apr 24th, 2002, 09:23 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 08:12 AM	#1
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	How do I reference my listbox to cells that are in a different file?

Apr 24th, 2002, 09:50 AM	#3
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	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.

Apr 24th, 2002, 10:21 AM	#4
itsmewhoelse New Member Join Date: Apr 2002 Location: Atlanta,Ga Posts: 7	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!

Apr 24th, 2002, 11:29 AM	#5
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	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 ]