You can do that with a simple formula in A5 and no command button but if you
want a button.

Assign this macro to a button from the Forms Toolbar.

Sub divide()
With ActiveSheet
.Range("A5").Value = Range("A1").Value / 2000
End With
End Sub


Gord Dibben MS Excel MVP

On Tue, 25 May 2010 08:58:01 -0700, Command Button Calculations <Command
Button wrote:

I am trying to insert a command button so that when the user fills out the
form and clicks the button, an amount will calculate. For example, the sales
price is in A1, when the user clicks the command button, the sales price will
be divided by 1000 then divided by 2 and the answer will appear in A5. Can
anyone help????