Synchronize data in two LISTBOXes
 

Workbook A uses a form that contains a LISTBOX whose source is a named range,
AccountAbbrev in Workbook B. A second named range in Workbook B,
AccountDescription, contains entries that correspond to the entries in
AccountAbbrev. I want the user to be able to see both lists and have them
synchronized on the form. Can I do that with two LISTBOXes?

Or, if a LISTBOX source is permitted to consist of more than one column of
data, could I just use a single LISTBOX and assign to its source a named
range consisted of both lists?

TIA,

Phil

Synchronize data in two LISTBOXes
 

I haven't received any comments on this question and I'm wondering if it
belongs in a different list -- such as excel programming. Before I repeat the
question there, can someone advise me of the protocol for putting a question
in more than one list at a time? Do I need to close this one and, if so, how
do I close it? I'm asking because I've been chastised in the past for
violating the protocol and I want to be certain that I don't repeat that
error. Also, I've found a possible solution to the original question and I'd
like some confirmation that my method is reasonable and that there's not a
better one.

"cellist" wrote:

Workbook A uses a form that contains a LISTBOX whose source is a named range,
AccountAbbrev in Workbook B. A second named range in Workbook B,
AccountDescription, contains entries that correspond to the entries in
AccountAbbrev. I want the user to be able to see both lists and have them
synchronized on the form. Can I do that with two LISTBOXes?

Or, if a LISTBOX source is permitted to consist of more than one column of
data, could I just use a single LISTBOX and assign to its source a named
range consisted of both lists?

TIA,

Phil