Newbie Question - Moving text from one cell to another

B

Buritoking

I just want to make a button that will take information from on
specific cell like v7 and move it to another specific cell like c2
This is probably really easy, bt i'm very new to this code thing. Than
you for any help
 
M

Mike Hughes

put a button on the sheet from the forms toolbar and try this

Sub Button1_Click()
ActiveCell.Cut
Range("C2").Select
ActiveSheet.Paste
End Sub


The code will cut the text from the selected cell and paste it into C2
 
G

Guest

-----Original Message-----
I just want to make a button that will take information from one
specific cell like v7 and move it to another specific cell like c2.
This is probably really easy, bt i'm very new to this code thing. Thank
you for any help.
Click to expand...
In cell if you want the info in cell v7 to also appear in
cell c2 you should just put "=v7" in cell c2 and then
whatever is in v7 will be in c2. Hope this helps and
answers your question.
 
Top