Dear Sir,
In the following procedure, the compiler displays this error message
Wrong number of arguments or invalid property assignment
and the offending line is
.Value = Format(b, "####") + "-" + Format(c, "00")
the compiler stops on word Format in above line
PHP Code:
Sub TOTALS()
Dim a As Long, b As Long, c As Long, FMI As Long, FM2 As Long, FM3 As Long, FM4 As Long, FM5 As Long, iLastRow As Long
a = 26240
b = Int(a / 40)
c = a - b * 40
With Me.TextBox11
.Value = Format(b, "####") + "-" + Format(c, "00")
End With
End sub
Bookmarks