How can I copy the text entered on a userform textbox to a sheet textbook? The code I have been trying is:
Where the userform is the Introcomments textbox and the sheet textbox is the Evalformintrocomments
Please Login or Register to view this content.
Last edited by Dfrost; 09-27-2015 at 10:23 PM.
you dont need the range
Please Login or Register to view this content.
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.
Thanks for the response. I keep getting subscript out of range as the error.
on the file i attached or on your version?
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:
Any advice? Thanks!!Please Login or Register to view this content.
if its still in the same run
Change this
toPlease Login or Register to view this content.
otherwisePlease Login or Register to view this content.
declare the worksheet
now ws1 would refer to worksheet(speakername)Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks