Shoutbox

Well guys, I'm making some work with Excel, and I wanted to put 2 comand buttons so they copy a value or result of one cell to the clipboard...
Anyway... Can someone point me to a tutorial that explains Visual Basic with Excel, please??? Or explains me what I need to do...???

Example of how excel is working:
In a easy way, a result is shown on the Cell (B2) depending on what I specify in other... So B2 has a function, that shows a value depending on what I specify... So, I want to make a button that copies the result on B2 on clipboard...


If someone could help, I would realy apreciate



And... Just adding this code that I've changed a little, but still doesn't work:


Private Sub CommandButton1_Click()
Dim n As Integer
For n = 17 To 17
  cell.Value(n, 2) = Copy(cell)
         
Next n
End Sub

Tutorials and info:

long URL 1
long URL 2

Also you may want to read this => http://www.developerfusion.co.uk/show/35/

Dont know the second part but i hope that helps

quote:

---

Originally posted by MicroWay
Thanks!!! I'm taking a look to them...
But remember, please, that if you've more information, please, post it... To help anybody: I'm talking about the macros.

---

Well, after days of search anf trying to learn something, I discovered that I'm not good on coding this...
And obviously this will be the last time I'll use VB with Excel, so could someone code it for me???
Little more information: I have one cel (B17) that with a function it calculates a value. I've made a ComandButton and I've placed it down the "result cell"(B17)... But I need a code that when the button is clicked, the result given on the cell (B17) will be copied to clipboard (as a text)....

Thanks in advance

If you want to copy the contents of a certain cell to the clipboard, use

code:

---

Private Sub CommandButton1_Click()
Range("B2").Copy
End Sub

---

But replace B2 with whatever cell you need.

Is this what you're looking for?

I don't believe!!! I get it too close in my tries....

Thanks anyway, fatfreechicken!!!