Hi All,
I have an output in one of my textboxes in my userform that returns a number to four decimal places. Ideally I would like the output value to be given to one decimal place. I currently have the below code, however it isn't working for me. Any help would be much appreciated.
Public Sub CommandButton1_Click()
TextBox7.Value = ((Val(TextBox4) * Val(TextBox3))) / Val(TextBox8)
TextBox7.Text = format(Value, "0.0")
TextBox12.Value = ((Val(TextBox18) * Val(TextBox15))) / Val(TextBox11)
TextBox9.Value = 100 - ((Val(TextBox8) / Val(TextBox4))) * 100
TextBox10.Value = 100 - ((Val(TextBox11) / Val(TextBox18))) * 100
End Sub
Thank you in advance,
Tubes
Bookmarks