I found a great piece of code to eliminate the #Error from displaying in calculated text boxes...(I have a text box that waits for the input of two others and then runs a calculation)
The problem is I don't know where to put it! I tried entering the function call into the Default property...didn't work
The code...which I set up in a module...is
Function removeerror(testvalue As Variant) As Variant
If Not(IsNumeric(testvalue)) Then
removeerror=0
Else
removeerror=testvalue
End If
End Function
On the default line I tried entering =removeerror([txtcostfactor]) and when then didn't work I tried
=removeerror([txtcostfactor].Value)
Where else can I put this code?
Confused
The problem is I don't know where to put it! I tried entering the function call into the Default property...didn't work
The code...which I set up in a module...is
Function removeerror(testvalue As Variant) As Variant
If Not(IsNumeric(testvalue)) Then
removeerror=0
Else
removeerror=testvalue
End If
End Function
On the default line I tried entering =removeerror([txtcostfactor]) and when then didn't work I tried
=removeerror([txtcostfactor].Value)
Where else can I put this code?
Confused