I am using the below code to populate a three-column ListBox. I am trying to get the ListBox to display the values in the formats shown. The ListBox displays the values but ignores the formats. Does anyone know how I can get the ListBox to display the values in the desired formats?
Thanks much for any help.
Dim VarDol as Currency
Dim RelVal as Double
Dim Xnum as Long
Defining the variables as String seemed to create random formats. Some items were shown as currency while others were shown as decimals (even numbers within the same column). Changing just one variable as String even impacted how the other variables were formatted in the ListBox. I guess I just don't understand what the ListBox is doing.