relating lists and cells

curph · Apr 5th, 2002, 04:48 AM

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 ]

Anne Troy · Apr 5th, 2002, 05:03 AM

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.

curph · Apr 5th, 2002, 05:05 AM

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

Anne Troy · Apr 5th, 2002, 05:11 AM

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

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

Apr 5th, 2002, 05:03 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Apr 5th, 2002, 05:11 AM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	No, that method works WITHOUT code/combobox/userform. Sorry. I don't know how to do the userform stuff. __________________ ~Anne Troy

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

Apr 5th, 2002, 04:48 AM	#1
curph New Member Join Date: Apr 2002 Location: Isle of Man Posts: 8	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 ]

Apr 5th, 2002, 05:05 AM	#3
curph New Member Join Date: Apr 2002 Location: Isle of Man Posts: 8	Thanks, but does that method work for a combobox in a userform? Will i need to write a macro?