ComboBox Variable AND list

Kindyr · #6 08-16-2020, 06:50 PM

That was my original question, how would I do that? This is the best I've come up with and I HAVE to have the space before |Mr. or the whole thing breaks when there isn't a value created for Prefix1.

Private Sub UserForm_Initialize()
Dim myPrefixes() As String
myPrefixes = Split(" |Mr. |Ms. |Det. |Dr. |Atty. |Rabbi |Ofc. |Sgt. |Cpl. |Maj. ", "|")
Prefix1.List = myPrefixes

If Prefix1.Value = Text Then
Prefix1 = ActiveDocument.Variables("Prefix1")
Else: ActiveDocument.Variables("Prefix1") = "Mr. "
End If

End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Combobox List	VBA-User	Excel Programming	4	01-07-2016 02:46 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
combobox list gets reset....please help	Deepa Shrestha	Word VBA	1	09-29-2013 09:30 PM
Adding a long list of values to a combobox in Word 2003?	ll4u76	Word VBA	1	04-13-2012 03:37 AM
Populating ComboBox or Drop Down list with contents of a text field	Billy_McSkintos	Word VBA	1	09-13-2011 05:50 AM