Listbox to select field name from data

JamesWood · #4 05-25-2021, 07:39 AM

Quote:

Originally Posted by gmayor

Do you mean like

Code:

Private Sub UserForm_Initialize()
Dim lngFld As Long
    With ActiveDocument.MailMerge.DataSource
        ListBox1.Clear
        For lngFld = 1 To .FieldNames.Count
            ListBox1.AddItem .FieldNames(lngFld)
        Next
    End With
End Sub

So I'm wondering how I can store one of the fields as a string. So basically on the listbox, I click on the desired field name, then when I click OK it stores that field name as a string. Any thoughts please? Thanks so much

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Yet another Multi-Select Listbox in Userform question	Javir	Word VBA	4	09-24-2019 01:01 AM
How to filter data before it is pulled into combobox/listbox AND remove data from listbox	Izzii0x	Excel Programming	8	05-24-2019 07:25 AM
Add-In creates ListBox from XLS, but data not saved in ppt	barbet	PowerPoint	0	05-26-2016 02:30 AM
How to use an ActiveX Control to insert a multi select listbox in Word	marksm33	Word	2	01-29-2014 05:21 PM
Multi-select listbox help	gvibe@hotmail.com	Word VBA	1	07-19-2013 10:54 AM