Round up to "0.5" using code

[glockster]

The typcail code in Excel VBA doesn't work in Word. How can I take a number in a TextBox in a UserForm and round it UP to 0.5 (ie: "1.2" becomes "1.5").
The following example codes didn't work:

TextBox1.Value = Round(TextBox2.Value * 0.03, 0.5)
TextBox1.Value = Round((TextBox2.Value * 0.03) / 0.5, 0) * 0.5
TextBox1.Value = -Int(-(TextBox2.Value * 0.03) * 0.5 / 0.5)
TextBox1.Value = -Int(-(TextBox2.Value * 0.03) * 2 / 2)

 

[Norie]

Eh, isn't 1.2*0.03 = 0.036.

Don't quite see how that would round up to 1.5, or am I missing something.

 

[Richard Schollar]

Hi

Something like:

Textbox1.Value = Int((cdbl(TextBox2.Value)+0.5)*2)/2

 

[glockster]

I abbreviated my original formula just to make it easier to understand.


"cbd1" returns an error saying sub or function not defined.

 

[Norie]

It's L not 1.

And it's db not bd.

 

[Richard Schollar]

I'm not sure what I provided will do what you want as a value like 1 will get rounded to 1.5, so work still needs to be done if you want that 1 to stay as 1.

 

[glockster]

Thanks guys!