[trustmeasfrnd]

hi ,
i want to create a button in excel that when clicked can copy a column say (from A1 to A25)and store it. now i can paste the same either in word or in notepad.
can it be created.

i think bomb #21 CAN HELP ME.

[bomb #21]

What version do you have? Which part is the problem, creating the button or the code?

[Rollin_Again]

Can you explain to us what exactly you are trying to accomplish? It's hard to provide a solution when we do not understand the "big picture"

Do you need to retain any type of formatting or just copying the value to another application? What determines the range or last row to copy? More details please.

Regards,
Rollin

[trustmeasfrnd]

creating the code...actually i never tried to use button also.. this is the first time i am doing so.

[trustmeasfrnd]

this is for rolling
actually its like i have coordinates of points (x,y) that i want to copy and directly paste it in word. they are in column A (x) and column B(y). now i want to copy that first column A(x) and then paste it in notepad or word.similarly for the column B(y).
so i want two buttons one for copying X coordinates andy other for y coordinate.

[trustmeasfrnd]

my version is Excel2003

[trustmeasfrnd]

i think this will do my work...

Private Sub CommandButton1_Click()
Range("A1:A25").Copy
End Sub

[trustmeasfrnd]

h guys
i am back with the solution as provided. Now i am attaching a file with it. i want to know that when the button is clicked it copies the values but i want that the user cant see that from where it has been copied. can it be done.i know this sheet can be better modified and this is possible.
please give me suggestion and if possible provide me better approact to do so.

with regards,
abhisekh

[bomb #21]

Copy to a hidden sheet first?

Range("A2:A25").Copy Sheets("Hidden").Range("A2")
Sheets("Hidden").Range("A2:A25").Copy

[Zack Barresse]

You still haven't explained everything. You want to copy your X and Y coordinates. Ok, we got that. But WHY are you copying them into Word or Notepad? What is the point? And why copy separately? What is the purpose here?

[trustmeasfrnd]

hey how to increase the font size in the attached excel sheet for list drop down box?
actually its too small...but i cant find any way. still i know it can be easily done but how ..that i dont know?

[Zack Barresse]

Can you explain any more than that? Is it data validation list drop down? If that is the case, there is no way. You must increase the zoom and lower the font of everything else to get it to look the same. Kind of crappy, but a simple workaround. May or may not work for you. If it doesn't, look at using a control (i.e. from the Controls Toolbox) where you can manipulate the font size.