Thread: Create listbox w/ checkboxes in VBA?

Can one create a listbox with checkboxes in VBA without having the userform already on a sheet? I can't seem to find any examples that actually include checkboxes. Here's the code I have:

Code:

Sub SecListBox(vSecList As Variant)

    Dim LB
    Set LB = Sheets(1).Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
    
    LB.ControlFormat.List = vSecList
    LB.ControlFormat.MultiSelect = 1
    'LB.ControlFormat.ListStyle = 1

End Sub

The ListStyle property fails every time and I don't know what I'm doing wrong.

Checkboxes in a list is only possible with the ActiveX controls.