Userform textbox as number keeps rounding up or down

[RobbieC]

Hi there, I have a userform with six textboxes which only accepts numbers

The first textbox is a 'startingDepth' which in this example is '1'

The next 4 input boxes are a 'count' of how many shovel loads make up 0.5 metres

As each of these 4 boxes receive an input, 0.5 is added to the 'startingDepth'

The last textbox is a TOTAL of the 'startingDepth' + 0.5 for each of the 4 boxes (in this example 1 + 0.5 + 0.5 + 0.5 + 0.5 = 3)

This all works fine for a WHOLE number as the 'startingDepth', but if the startingDepth is 1.5, it rounds it down to 1 and if it is 1.8, it will round it up to 2

Is there a way I can convert my initial number to 2 decimal places?

Thanks

 

[Rick Rothstein]

Hi there, I have a userform with six textboxes which only accepts numbers

The first textbox is a 'startingDepth' which in this example is '1'

The next 4 input boxes are a 'count' of how many shovel loads make up 0.5 metres

As each of these 4 boxes receive an input, 0.5 is added to the 'startingDepth'

The last textbox is a TOTAL of the 'startingDepth' + 0.5 for each of the 4 boxes (in this example 1 + 0.5 + 0.5 + 0.5 + 0.5 = 3)

This all works fine for a WHOLE number as the 'startingDepth', but if the startingDepth is 1.5, it rounds it down to 1 and if it is 1.8, it will round it up to 2

Is there a way I can convert my initial number to 2 decimal places?

I think it would be helpful if you showed us the code that puts the total into that last TextBox.

 

[RobbieC]

Hi Rick, sorry, I just answered my own question....

I had:

dim startingDepth as Integer

which rounds up or down... I have changed it to

dim startingDepth as Double

which now allows the decimal place to work!