Hi,
Is there a way to format one column in a listbox? I have one column that I'd like to display in an accounting type format (ex. $100.00).
I'm populating the listbox using this code (where Results is an array):
With ProductsListBox
.ColumnCount = 4
.Clear
.List = Application.Transpose(Results)
End With
I've heard that it's not possible to format a column of the listbox, but it might be possible to format the array prior to loading it into the listbox.
I'm currently populating one of the dimensions of the array like below:
Results(4, countOfResults) = Sheet2.Cells(searchRow, manPriceCol)
Any suggestions or tips would be appreciated.
Bookmarks