1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
Public Const Brouzouf = "# ###.00"
Private Sub Total() 'total du devis
Dim TotalTTC As Double, TotalHT As Double
Dim Ctl As InlineShape
TotalTTC = Val(Tables(1).Cell(3, 3).Range.Text) 'valeur du modèle
For Each Ctl In ActiveDocument.InlineShapes
If Left(Ctl.OLEFormat.Object.Name, 7) = "TextBox" Then _
TotalTTC = TotalTTC + Val(Ctl.OLEFormat.Object.Text) '+ valeur des options
Next Ctl
TotalHT = TotalTTC / 1.196
Tables(2).Cell(2, 3).Range.Text = Format(TotalTTC, Brouzouf)
Tables(2).Cell(2, 1).Range.Text = Format(TotalHT, Brouzouf)
Tables(2).Cell(2, 2).Range.Text = Format((TotalTTC - TotalHT), Brouzouf)
Init
End Sub |
Partager