TextBox math

[Big Lar]

Can TextBox4.Value be rounded up?

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o>

 </o:p>
Private Sub TextBox2_AfterUpdate()<o:p></o:p>
TextBox27.Value = (TextBox4.Value) / 2<o:p></o:p>
End Sub

 

[JackDanIce]

This code just worked for me:

Sub Assimilation()
MsgBox Round(3 / 2, 0)
End Sub

You could try something similar in below?

 

[Big Lar]

This code just worked for me:

Sub Assimilation()
MsgBox Round(3 / 2, 0)
End Sub

You could try something similar in below?

You lost me there.

I want the value of TextBox27 to be half the value of TextBox4, rounded up to the nearest interger.

 

[VoG]

Try

Private Sub TextBox2_AfterUpdate()
TextBox27.Value = WorksheetFunction.RoundUp(TextBox4.Value / 2, 0)
End Sub

 

[Big Lar]

Try

Private Sub TextBox2_AfterUpdate()
TextBox27.Value = WorksheetFunction.RoundUp(TextBox4.Value / 2, 0)
End Sub

Perfect!
Thank you very much.