Resetting cells

  • Thread starter Thread starter Chuck
  • Start date Start date
C

Chuck

I want to create a Command Button that when pressed will set the value of
cell D10, for example, to the value in C10. I suspect there's an easy
solution, but not yet found it in the VBA book I have. Thanks.
 
Enter this in your VBA module.

Sub ChangeValue()
Range("D10").value = Range("C10").value

End Sub

Then create a command button, and assign it the ChangeValue macro.
 
Back
Top