txtBox to clipboard [Resolved]

Hi all,

I have a form that has a text box and cmd button on it. What i want to happen is when i press the cmd button it to take the text written in the txt box and paste it into the cell on the excell spreadsheet

Thanks for any help given :)

is this ALL in excel or VB with Excel?

VB for Applications that comes with excel

ok.. which textbox control did you use? (From the Controls Toolbox command bar or the Forms Command bar?)

Controls Toolbox

easy one ;) (Sorry for not getting back quicker.. got side tracked lol)

VB Code:

Private Sub CommandButton1_Click()
    
    Range("A1") = Sheet1.TextBox1.Text
    
End Sub

nah this doesnt work m8 ??? :(