Hi,
I need help to create a code that makes me save data from a userform to the worksheet from B to J.
But it has to save the data in the next empty line every time. I will use it to register new clients in the worksheet.
Hope somebody can help me solv this.
Thanks in advance
Best regards
Øystein Breivik
Last edited by Oeysbrei; 01-15-2018 at 02:16 PM. Reason: Change samplefile
Can you please upload an excel sheet not this pdf file.
Regards,
Thangavel D
Appreciate the help? CLICK *
Hi Thangavel D!
Now i Have changed the file. There are so many different opinions of witch files to attache, so thats why I chose the PDF.
Regards,
Øystein Breivik
In the attached excel, the code & userform is missing. Could you please upload the correct file?!
Try this code & modify to your requirement.
Please Login or Register to view this content.
Removed attacedment
Last edited by Oeysbrei; 01-15-2018 at 01:15 PM. Reason: contains personal information
Hello,
Code is missing in userform1 & the form is incomplete, because there is no update/cancel/ok buttons...
Hi Thangavel D!
It has all been a mess, so now I have made changes to the files and removed the files that has been posted before.
I hope that these files has what you need to help me solve this challenge. The PDF file explains where to save the data.
Thank you in advance!
Regards,
Ø. Breivik
Here you go..
Please use naming convention, when naming the userform objects, refer the attached screenshot. Which helps when you coding.
userform_naming.PNG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks