|
-
Jun 22nd, 2006, 04:09 AM
#1
Thread Starter
New Member
 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 
Last edited by Sparky_GPR; Jun 23rd, 2006 at 03:38 AM.
-
Jun 22nd, 2006, 07:11 AM
#2
Re: txtBox to clipboard
is this ALL in excel or VB with Excel?
JPnyc rocks!! (Just ask him!)
If u have your answer please go to the thread tools and click "Mark Thread Resolved"
-
Jun 22nd, 2006, 08:42 AM
#3
Thread Starter
New Member
Re: txtBox to clipboard
VB for Applications that comes with excel
-
Jun 22nd, 2006, 08:56 AM
#4
Re: txtBox to clipboard
ok.. which textbox control did you use? (From the Controls Toolbox command bar or the Forms Command bar?)
JPnyc rocks!! (Just ask him!)
If u have your answer please go to the thread tools and click "Mark Thread Resolved"
-
Jun 22nd, 2006, 09:08 AM
#5
Thread Starter
New Member
-
Jun 22nd, 2006, 12:49 PM
#6
Re: txtBox to clipboard
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
JPnyc rocks!! (Just ask him!)
If u have your answer please go to the thread tools and click "Mark Thread Resolved"
-
Jun 23rd, 2006, 03:09 AM
#7
Thread Starter
New Member
Re: txtBox to clipboard
nah this doesnt work m8 ??? 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
