ListBox formatting

[ProteanBeing]

Is it possible to carry the format of the items in a multi-column list box? On of my columns is a money but displays as a regular decimal number.

[Carl A]

If you use the Rowsource property it will retain the formatting.

Private Sub UserForm_Initialize()
ListBox1.RowSource = "a1:c1"
end sub

[Carl A]

Ignore