Microsoft Office Forums - View Single Post - [Solved] Listbox to select field name from data

JamesWood · 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