VBA code to copy data from text box and input into a cell in another worksheet

**bobaftt** · 03-24-2009, 10:49 AM

This is probably far easier then I am making it but I need to take the information that is in a textbox created through the control toolbox and copy and paste that information into a cell on different tab in the workbook. I have tried the infamous google and haven't been able to find much. The excel books that I have don't really touch on the control toolbox functions.

Thanks a bunch for any help!!!

**MickG** · 03-24-2009, 11:00 AM

Hi, Right Click the TextBox in Design Mode, Select "View Code" and Paste code into VB Window.

Please Login or Register  to view this content.

Mick

**bobaftt** · 03-24-2009, 12:30 PM

wow that was fast. Thanks so much!

**dyodyo** · 03-29-2011, 12:55 AM

Hi,

I was trying to copy the data entered into the textbox of my userform but was not able to paste them upon pressing my command button.

Here's my codes:

Private Sub CommandButton1_Click()

TextBox1.Copy
TextBox2.Copy
TextBox3.Copy
Range("A2").Select

Do
If IsEmpty(ActiveCell) = False Then
ActiveCell.Offset(1, 0).Select
End If

Loop Until IsEmpty(ActiveCell) = True

'portion wherein I was not able to add a code to paste it in column

End Sub

**pike** · 03-29-2011, 01:49 AM

dyodyoYour post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

VBA code to copy data from text box and input into a cell in another worksheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to copy data from text box and input into a cell in another worksheet

Re: VBA code to copy data from text box and input into a cell in another worksheet

Re: VBA code to copy data from text box and input into a cell in another worksheet

Re: VBA code to copy data from text box and input into a cell in another worksheet

Re: VBA code to copy data from text box and input into a cell in another worksheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions