Private Sub CommandButton1_Click()
Selection.GoTo What:=wdGoToBookmark, Name:="Result"
Res = TextBox1.Value * TextBox2.Value \ 1000
The problem is that it only returns the value as an integer and I need it to shows decimals, but rounded up to 2 decimal places.
I think I need to use the 'round' statement, but does this round up or to nearer. Anyway, even if I do it still returns the answer as an integer and not decimals.
On further hunting, I thought I needed to Dim the Res 'As Double', but this hasn't worked either.