Big_Shrimp
10-03-2013, 11:14 AM
Hello All,
I am using Word 2010 on a Windows 7 64-bit machine. I have created a template with a custom userform and included a Listbox control. I used the 1-fmMultiSelectMulti property on the listbox so that you can pick 1 or 2 of the 3 items.The listbox contains a list of names by order of the person's job title but when someone selects the names that they want to appear in the document, it seems the names come out in alphabetical order instead of job title order as I have them listed. Is there some property or code that I can use to get them to come out in the order that I have them listed as?
Example
My code reads:
Listbox1 "Smith, Pres."
Listbox1 "Doe, Sr. Vice Pres."
Listbox1 "Jones, Vice Pres."
On the Userform, it you were to select Smith and Jones, it would appear in the document as Jones and Smith. I want them to appear as Smith and Jones.
Thanks for any and all help.
I am using Word 2010 on a Windows 7 64-bit machine. I have created a template with a custom userform and included a Listbox control. I used the 1-fmMultiSelectMulti property on the listbox so that you can pick 1 or 2 of the 3 items.The listbox contains a list of names by order of the person's job title but when someone selects the names that they want to appear in the document, it seems the names come out in alphabetical order instead of job title order as I have them listed. Is there some property or code that I can use to get them to come out in the order that I have them listed as?
Example
My code reads:
Listbox1 "Smith, Pres."
Listbox1 "Doe, Sr. Vice Pres."
Listbox1 "Jones, Vice Pres."
On the Userform, it you were to select Smith and Jones, it would appear in the document as Jones and Smith. I want them to appear as Smith and Jones.
Thanks for any and all help.