how to insert excel sheet in vba userform

I believe the closest you can come is like:

With ListBox1
        .ColumnCount = 5
        .ColumnWidths = "25;40;40;100;100"
        .RowSource = ws1.Range("B10:F58").Address
    End With