How do I add a command button on a worksheet to "paste" from the .
 

I am making an excel spreadsheet and I want to create a command button on the
sheet itself to where a user can go to another area, copy materal, come back
to the worksheet and click on the command button to paste information onto
the sheet to a specific cell without using keyboard shortcuts or the mouse..
Is this possible and how?

sheets("sourcesheet").range("a2:x200").copy
sheets("destinationsheet").range("a1")

--
Don Guillett
SalesAid Software

" wrote
in message ...
I am making an excel spreadsheet and I want to create a command button on
the
sheet itself to where a user can go to another area, copy materal, come
back
to the worksheet and click on the command button to paste information onto
the sheet to a specific cell without using keyboard shortcuts or the
mouse..
Is this possible and how?

Thanks... One problem... Tell me if I am doing this wrong... I went to the
"control toolbox" and clicked "design" and dragged a "control button" to the
sheet.. doubleclicked the button to get to the Visual Basic and copied and
pasted the formula into the Private Sub CommandButton1_Click ()... I changed
the "sourcesheet" to "sheet1" because that is where I am going to have the
button, but what do I need to change the "destinationsheet".range("a1) to?
Thanks again.. This is new to me..

"Don Guillett" wrote:

sheets("sourcesheet").range("a2:x200").copy
sheets("destinationsheet").range("a1")

--
Don Guillett
SalesAid Software

" wrote
in message ...
I am making an excel spreadsheet and I want to create a command button on
the
sheet itself to where a user can go to another area, copy materal, come
back
to the worksheet and click on the command button to paste information onto
the sheet to a specific cell without using keyboard shortcuts or the
mouse..
Is this possible and how?

The parameters should be changed to suit in terms of ranges and sheet names.
For the destination sheet, change the name to the sheet where you want to
copy to. If all is on the same sheet, you may simply omit the sheets("")
part.

--
Don Guillett
SalesAid Software

" wrote in
message ...
Thanks... One problem... Tell me if I am doing this wrong... I went to the
"control toolbox" and clicked "design" and dragged a "control button" to
the
sheet.. doubleclicked the button to get to the Visual Basic and copied and
pasted the formula into the Private Sub CommandButton1_Click ()... I
changed
the "sourcesheet" to "sheet1" because that is where I am going to have the
button, but what do I need to change the "destinationsheet".range("a1) to?
Thanks again.. This is new to me..

"Don Guillett" wrote:

sheets("sourcesheet").range("a2:x200").copy
sheets("destinationsheet").range("a1")

--
Don Guillett
SalesAid Software

"
wrote
in message ...
I am making an excel spreadsheet and I want to create a command button
on
the
sheet itself to where a user can go to another area, copy materal,
come
back
to the worksheet and click on the command button to paste information
onto
the sheet to a specific cell without using keyboard shortcuts or the
mouse..
Is this possible and how?