relating lists and cells

[curph]

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]

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]

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

 

[Anne Troy]

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

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