ListBox percent format in UserForm

[rmachbitz]

I want my code to work for Range L52:L60 as text and Range O52:O60 as a percent. Thank you!

Private Sub UserForm_Initialize()
       
   'Display initial listbox
    Me.ListBox1.ColumnCount = 4
    Me.ListBox1.ColumnWidths = ("90;0;0;90")
 
    'Load Worksheet Range directly to a ListBox
    Dim rng As Range
    Set rng = Sheet4.Range("L52:O60")
   
       
    Me.ListBox1.List = rng.Cells.Value
   
 
End Sub