command button
 

Hello,

I would like to program a command button to take the value of one cell (i.e.
A1), divide this value by a fixed number (i.e. 10) and then place the result
in a difference cell (i.e. A2).

Ideas?
--
Thank-you and all suggestions are appreciated.

command button
 

Range("A2")=Range("A1")/10

Place in command button click event
--
steveB

Remove "AYN" from email to respond
"Anauna" wrote in message
...
Hello,

I would like to program a command button to take the value of one cell
(i.e.
A1), divide this value by a fixed number (i.e. 10) and then place the
result
in a difference cell (i.e. A2).

Ideas?
--
Thank-you and all suggestions are appreciated.