Help in Coding

[Rahulwork]

Hello all

i want a coding on button to select the cell value only and copy that. please find below example
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Rahul on 08/09/2013[/TD]
[TD]_____[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i want to create button on B1 that i know how can we create button. but i want when i click on that button it will select the cell A1 value and then copy only.

is it possible by coding..?? help me please to solve this problem and do let me know in case of any confusion...

 

[sdsurzh]

Hi,

Try this.

Sub copys()
Range("A1").Copy
End Sub

Thanks,
SK

 

[DeusXv]

Where do you want the Value of cell A1 copied to ?

Cos you can just use

Range("A1").Copy

 

[Rahulwork]

sdsurzh i want it on buttton, could u please tell me complete coding for the same. becuase it's not working on button

 

[Rahulwork]

on form i want to paste but i will do that with ctrl + V but there i just want to copy

 

[Rahulwork]

Sub Button1_Click()
Range("D5").Copy
End Sub

it will be coding but buddy this is copy the complete cell. i want select the value like "we drag mouce on text or value and highlight". and then copy

 

[DeusXv]

on form i want to paste but i will do that with ctrl + V but there i just want to copy

When you have the button the spreadsheet, click design mode in the developer tab and then double click the command button and then paste this into it.

Private Sub ToggleButton1_Click()

Range("A1").Copy


End Sub