Hello guys,
I have the following code:
What I'm trying to obtain is to copy the textboxes values (each text box value...) into a range of consecutive cells (each Tb into it's appropriate cell...)
Please Login or Register to view this content.
The textboxes are on a UserForm
I need your help making this loop work correctly.
Much appreciate your help.
Octavian
Try this:-
Regards MickPlease Login or Register to view this content.
Hi MickG,
Thank you very much for your feedback. In fact the code you provided is almost there, only one little aspect is missing... I need that the For Each syntax to connect all the TextBoxes with names starting with "D"
I have multiple textboxes on my UserForm and I've named them with a letter & a number ex: D1, D2, D3,...,Dn (of course I have also others that fallow the same pattern... A1,A2,etc...)
I will later modify the code in order to link all the "A"-Tb and "B"-Tb, etc.. to different rows / consecutive cells...
I tried to link them based on their progresive names... On the other hand your code links all of them.
I've inserted here an img. of my test UserForm to provide better insight.
UserForm.jpg
Thanks again for your prompt reply.
Last edited by Hovoruha Octavian; 02-02-2019 at 06:35 PM.
Got it!
I've modified the IF statement in order to take into account the first letter in the TextBox name. Also added a second variable as Long in order to have the values from the "A" Tb's inserted in the row bellow.
So everything worked out just fine based on your BASE code.Please Login or Register to view this content.
Thanks again MickG!!!
Last edited by Hovoruha Octavian; 02-02-2019 at 06:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks