A rotina de calculo está com erro
o nomo do controle está errado e falta incremento da variavel aN
Private Sub TotalGeral()
Dim Valor As Double
Dim c As Control
Dim aN
Valor = 0
aN = 1
For Each c In Controls
If TypeName(c) = "TextBox" Then
If c.Name = "txtVlrTot" & "0" & aN And IsNumeric(c.Text) Then
Valor = Valor + CDbl(c.Text)
aN = aN + 1
End If
End If
Next
txtVlrTotGeral.Text = Format(Valor, "R$ #,##0.00")
End Sub
Porem no seu modelo, como há muitos controles prefeiro utilizar conforme rotina abaixo:
Private Sub TotalGeral1()
Dim Tot1 As Double, Tot2 As Double, Tot3 As Double
Dim Tot4 As Double, Tot5 As Double, Tot6 As Double
Dim Tot7 As Double, Tot8 As Double, Tot9 As Double, Tot10 As Double
Dim Valor As Double
Valor = 0
'Compatibilização de valores
If txtVlrTot01 = "" Then
Tot1 = 0
Else
Tot1 = txtVlrTot01
End If
If txtVlrTot02 = "" Then
Tot2 = 0
Else
Tot2 = txtVlrTot02
End If
If txtVlrTot03 = "" Then
Tot3 = 0
Else
Tot3 = txtVlrTot03
End If
If txtVlrTot04 = "" Then
Tot4 = 0
Else
Tot4 = txtVlrTot04
End If
If txtVlrTot05 = "" Then
Tot5 = 0
Else
Tot5 = txtVlrTot05
End If
If txtVlrTot06 = "" Then
Tot6 = 0
Else
Tot6 = txtVlrTot06
End If
If txtVlrTot07 = "" Then
Tot7 = 0
Else
Tot7 = txtVlrTot07
End If
If txtVlrTot08 = "" Then
Tot8 = 0
Else
Tot8 = txtVlrTot08
End If
If txtVlrTot09 = "" Then
Tot9 = 0
Else
Tot9 = txtVlrTot09
End If
If txtVlrTot10 = "" Then
Tot10 = 0
Else
Tot10 = txtVlrTot10
End If
Valor = Tot1 + Tot2 + Tot3 + Tot4 + Tot5 + Tot6 + Tot7 + Tot8 + Tot9 + Tot10
txtVlrTotGeral.Text = Format(Valor, "R$ #,##0.00")
End Sub
Veja em seu arquivo
Postado : 19/11/2014 9:05 am