button macro help

[greg7468]

Hello all,
I have a command button by where I want to say transfer the values i
A1 to the active cell in the sheet. Could someone please help me wit
the macro.
Thank you in advance

 

[Chip Pearson]

Greg,

Try something like

ActiveCell.Value = Range("A1").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Gord Dibben]

greg

To transfer the value use

Sub Move_Value()
Range("A1").Cut Destination:=ActiveCell
End Sub

To copy the value use

Sub Copy_Value()
ActiveCell.Value = Range("A1").Value
End Sub

Gord Dibben Excel MVP

 

[greg7468]

thank you both for your replies, you really do save people many hour
trying in vain to find the correct solution