Creating a userform with VBA

On a worksheet i have a list of names in Column A the list length can vary this is why i want to create a userform using VBA. The form just wants a checkbox with name next to it for each name in column A. If the checkbox is ticked I want a 'Y' in Column B next to the corresponding name. Hope you can understand and thankyou for any help

You can use a Listbox to do that by setting 2 properties.
No need to create the userform on the fly.

Userform with Listbox.
Data in A2:B6

Private Sub UserForm_Initialize()

    Dim rngData As Range
    Dim lngIndex As Long
    
    Set rngData = Range("A2:B6")
    
    With ListBox1
        .ColumnCount = 1
        .MultiSelect = fmMultiSelectMulti
        .ListStyle = fmListStyleOption
        For lngIndex = 1 To rngData.Rows.Count
            .AddItem rngData.Cells(lngIndex, 1).Value
            .Selected(lngIndex - 1) = (rngData.Cells(lngIndex, 2).Value = "Y")
        Next
    End With

End Sub

You would need to do the reverse of loading the listbox.

You need to go through the list and if an item is selected write a Y to the correct cell. And clear Y from cell if the item is no longer selected.