Per formattare un numero decimale per eccesso o per difetto, puoi usare la funzione Format. Ad esempio:
codice:
Private Sub Command1_Click()
Dim dblNumeroDec1 As Double, dblNumeroDec2 As Double, _
dblNumeroDec3 As Double, dblNumeroDec4 As Double
dblNumeroDec1 = 1000.4
dblNumeroDec2 = 1000.5
dblNumeroDec3 = 1000.6
dblNumeroDec4 = 1000.7
MsgBox (Format(dblNumeroDec1, "#,##0"))
MsgBox (Format(dblNumeroDec2, "#,##0"))
MsgBox (Format(dblNumeroDec3, "#,##0"))
MsgBox (Format(dblNumeroDec4, "#,##0.00"))
End Sub
:ciauz: