Listbox Date and amount text Type

Dear all,
How to build a list box that shows date = 01/11/2017 amount = 1.200,00
Date is on C and amount is on G

I use below code to load the data to listbox

Please Login or Register  to view this content.

We can use the range's Text property rather than Value to use the Number Format. e.g.

Please Login or Register  to view this content.