Can anybody explain to me how we do this in exel?

Question

what should i type in VBA so that it can do math calculations and show the results in a box. for example i want to type a ramdon number in a box then press a button and it will divide it by 15 then add 100 to it and show the result in a box

Answer 1

If you want it to round the number:

Dim theValue As Integer
Dim theRow , theColumn As Integer
'set theRow and theColumn to the cell you want to look at here
theValue = Cells(theRow, theColumn).Value
theValue = theValue / 15 + 100
MsgBox theValue, vbOKOnly, "[Insert Title Here]"

If you don't want it to round, replace "Dim theValue As Integer" with "Dim theValue As Double"

Answer 2

in excel, you can put a formula in a box.

=B2/15+100