Have formula results/textbox to round value at 0 decimal places

Hi everyone,

I have the following bits of code:

Please Login or Register  to view this content.

All I'm trying to do is have the number value which shows up in the NewScore textbox round the NewScore.Value to 0 decimal places. As i have it right now, the value doesn't come up at all. When I remove the Private Sub NewScore_Change macro then the value comes up but its to multiple decimal places.

Any ideas?

Thanks!!

Hi Norie,

Using "'###" gave me an error, but when I changed Number to NewScore.Value in the NewScore_Change code it worked. Thanks!