UserForms - Many ComboBoxes One List

Hi Guys

Does anyone know how to link comboxboxes in userforms to a list in MS Word?

I have userforms with multiple comboboxes relating to Country Lists. I can link using VBA through [Me.ComboBox*.List = Split("ALBANIA ANGOLA BERMUDA")] but currently have to write the same code for each combobox.

I have 10 Comboboxes with 120 Countries (same list).

Any help appreciated.

Thanks

Orlando

Thanks Paul.....

Solution works.

Orlando

Hi Paul

If this breaks forum rules, please advise and ill post to new thread.

However, Quick Question: Have responded to confirm solution works... do you know how i can add spaces to the String for countrys with more than 1 word (i.e. Great Britain).

Can get the following to work:

[Const ListItems As String = "Great" & "_" & "Britain America Ireland"] result for GB is Great_Britain, when i move the underscore e.g. [Great & "_" "Britain] the string adds britain to another line.

Any help greatly appreciated.

Cheers

Orlando