Hi RomperStomper

Thanks for your reply.

It doesn't, unfortunately, solve for my problem, unless I'm (quite possibly) missing something.

I have two ListBox controls, "Organisation" and "Contacts", lbOrganisation and lbContacts respectively. lbOrganisation has a 2 column Named Range associated with it but displays only Column 1. Column 1 contains the name of the organisation, column 2 the name of the Named Range containing the list of contacts for that organisation.

So
Organisation
Org1_Name Org1_Contact_List
Org2_Name Org2_Contact_List
Org3_Name Org3_Contact_List

The Org1_Contacts_List to Org3_Contact_List values are the names of Named Ranges thus

Org1_Contact_List
Contact 1 at Org 1
Contact 2 at Org 1
Contact 3 at Org 1

Org2_Contact_List
Contact 1 at Org 2
Contact 2 at Org 2

Org3_Contact_List
Contact 1 at Org 3
Contact 2 at Org 3
Contact 3 at Org 3
Contact 4 at Org 3
Contact 5 at Org 3

If I select Org2_Name in lbOrganisation, I want to display Org2_Contact_List in lbContacts.

I'm able to set the lbContacts.RowSource with the new Named Range I need.

My challenge(!) is getting the lbContacts control on the form to display

Contacts
Contact 1 at Org 2
Contact 2 at Org 2

The default value for lbOrganisation is Org1_Name and lbContacts displays the Org1_Contact_List as expected on entry to the form. I cannot find any way of changing the displayed list in lbContacts when changing the selection lbOrganisation e.g. setting lbOrganisation "Org2_Name" causing lbContacts to display the contents of the Org2_Contact_List.

Selecting "Contact 2 at Org 1" on lbContacts having changed lbOrganisation to Org2_Name and submitting the form saves "Contact 2 at Org 2" to the underlying sheet. The correct RowSource is being set on changing lbOrganisation and the correct list index value is being saved.

The only thing lacking is being able to display the contents of Org2_Contact_List to the user so that they can see what they are selecting.

If you listen very carefully, you may hear this distant echo of me banging my head against the nearest wall over this.

Any help you or anyone in the community can offer is deeply appreciated.

Best regards

Martyn