Hello,

I would like to give the user of an application feedback on found data
after a search in a simple msgbox.

the box will contain date, some integers and a few decimal values.
Problem is; how do I format some figures to have, say 2 decimals
shown, use 'thousand-separator' etc? Can I use something like
NumberFormat = "#,##0.00" in separate items of the msgbox?

Here is my code:
For j = 3 To cellsDown
If loanNumber = Cells(j, 19).Value Then
MsgBox ("Følgende lån funnet:") & vbCrLf & vbCrLf & "Låntaker: " &
Cells(j, 3).Value _
& vbCrLf & "Valuta: " & Cells(j, 9).Value & vbCrLf & "Credit: " &
Cells(j, 7).Value _
& vbCrLf & "SLS Lån: " & Cells(j, 8).Value & vbCrLf & "Dato
utbetalt: " & Cells(j, 25).Value _
& vbCrLf & "Beløp utbetalt: " & Cells(j, 26).Value & vbCrLf &
"Kurs utbetalt: " & Cells(j, 27).Value _
, vbYesNo, "Detaljer"
Exit Sub
End If
Next j



Best regards,
NorTor