Hi, i have a userform which has around 20 textbox for user to fill in. I have rename the textbox according to their nature. Then after renaming them, i discover i can onli link each individual textbox to each cell, cant use For Loop base on textbox1 textbox2 etc.
Would it be faster if i use For Loop to transfer all the 20 textbox value to individual cell or one code for each Textbox to be transfer to individual cell? If its faster, i would rename them back according to textbox1 textbox2 etc.
Hi,
Can you brief me as in how will you run a loop on textboxes?
Cheers!
Deep
Cheers!
Deep Dave
I doubt it's faster with a loop but your code looks far better and is shorter that way and takes away writing time.
I never rename Objects for coding purposes.
@ Deep
Something like this writes 10 textbox values to 10 rows in worksheet.
Please Login or Register to view this content.
Last edited by bakerman2; 04-30-2018 at 04:59 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks