S
sam
Not sure if this is what you are after or not...see how
you go.
you need two text boxes. Enter the number in the first
and have a control source in the second of roundcc
([firsttextbox])
Changing the const factor will chnage the number of
decimal places.
Option Explicit
Const Factor = 10000
Function RoundCC(X)
RoundCC = Int(X * Factor + 0.5) / Factor
End Function
you go.
you need two text boxes. Enter the number in the first
and have a control source in the second of roundcc
([firsttextbox])
Changing the const factor will chnage the number of
decimal places.
Option Explicit
Const Factor = 10000
Function RoundCC(X)
RoundCC = Int(X * Factor + 0.5) / Factor
End Function