« Macros-commandes VBA/Manipulation des variables » : différence entre les versions

Contenu supprimé Contenu ajouté
Ligne 139 :
Sub arrondir()
a = "5,5"
MsgBox Int(a) ' 5
MsgBox Fix(a) ' 5
MsgBox Round(a) ' 6
MsgBox Format(a, 0) ' 6
End Sub
</source>
Donne 5, 5, 6, 6.
 
Sub arrondir2()
<source lang=vb>
a = 1"5,14"
MsgBox Int(a) ' 5
msgbox round(a)
MsgBox Fix(a) ' 5
b = 1,9
MsgBox Round(a) ' 5
msgbox round(b)
MsgBox Format(a, 0) ' 5
End Sub
</source>