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 :)
Printable View
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 ??? :(