+ Reply to Thread
Results 1 to 6 of 6

copy text from userform textbox to sheet textbox

  1. #1
    Registered User
    Join Date
    09-19-2015
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    12

    copy text from userform textbox to sheet textbox

    How can I copy the text entered on a userform textbox to a sheet textbook? The code I have been trying is:

    Please Login or Register  to view this content.
    Where the userform is the Introcomments textbox and the sheet textbox is the Evalformintrocomments
    Last edited by Dfrost; 09-27-2015 at 10:23 PM.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: copy text from userform textbox to sheet textbox

    you dont need the range
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by humdingaling; 09-27-2015 at 11:24 PM. Reason: mock setup attached
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    09-19-2015
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    12

    Re: copy text from userform textbox to sheet textbox

    Thanks for the response. I keep getting subscript out of range as the error.

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: copy text from userform textbox to sheet textbox

    on the file i attached or on your version?

  5. #5
    Registered User
    Join Date
    09-19-2015
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    12

    Re: copy text from userform textbox to sheet textbox

    Thanks again!! Your code was correct, I actually had a spelling error (an "s" at the end of form). But... I guess my issue was bigger than I thought. So it does copy to the textbox, but earlier in the routine I am creating a new sheet and renaming that sheet. Then I print a bunch of values to that newly named sheet. I did not realize that this code would copy back on the generic sheet "Eval form" that the new sheet was based on. I need it to paste the textbox input to the new sheet along with the other data. The prior code looks like this:

    Please Login or Register  to view this content.
    Any advice? Thanks!!

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: copy text from userform textbox to sheet textbox

    if its still in the same run

    Change this
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    otherwise
    declare the worksheet

    Please Login or Register  to view this content.
    now ws1 would refer to worksheet(speakername)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 08-18-2015, 04:13 PM
  2. [SOLVED] Excel 2010 - Userform - display date from textbox in a label or textbox in 'ddd' format
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 10:54 PM
  3. Replies: 23
    Last Post: 07-12-2014, 07:09 PM
  4. Replies: 4
    Last Post: 01-29-2014, 05:53 AM
  5. VBA - Macro Code to copy textbox text to another worksheet textbox
    By nitram lowm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2013, 08:39 AM
  6. Replies: 3
    Last Post: 05-07-2012, 09:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1