Userform for data entry

Hi, I have a userform where staff will go into "Add case" tab to enter data. After selecting Sample Type, entering Marking and Mortuary No, they will click "Add". This command will add the data into textbox16. One problem here is that the "Case assigned" number should remain as "DVI-00001" if "Add" command is clicked, such that the next data added into textbox16 will have "DVI-00001-002". The "Case assigned" number should change to "DVI-00002-001" if the "Prelog" command is clicked. I'm having problems trying to make that happen.

Staff will carry on adding to the textbox based on how much data there is, after which, they will click Prelog. This command will add the data into the worksheet. I'm having problems trying to get the data from textbox16 into the worksheet. The data needs to be split into the respective rows and columns according to the same heading.

Any help is appreciated

Your requirements are not entirely clear, but give these changes a try and let me know how it goes.

Form initialize code:

Please Login or Register  to view this content.

Add button code:

Please Login or Register  to view this content.

Prelog button code:

Please Login or Register  to view this content.

Try these changes:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Edit:
It will not populate properly if you choose "Body Part", since it contains a space.
You can try a different column separator, like underscore ( _ )
or revamp your form and use multi-column listbox instead of a multi-line textbox.

You need the With statement block, don't remove them.

Please Login or Register  to view this content.

Oh silly me... Thanks for correcting. I attached a revised version of the previous workbook. After users have filled in info, clicked "Add" and clicked "Receive in lab", how do I code the "transfer custody" button such that what is in textbox16 will have the correct custodian? example:
Textbox16 has these info
Case: DVI-00001-001 Sample Type: Bone Marking: 1234 Mortuary ID: M1234
Case: DVI-00001-002 Sample Type: Body part Marking: 1235 Mortuary ID: M1235
Clicking "Receive in Lab" will transfer these info into respective columns in worksheet. Column E will be populated with textbox14.
Now users need to transfer the custody to another person or location. They do so by selecting from combobox5 and click "Execute". Column F should populate the new custodian for DVI-00001-001 and DVI-00001-002

Try this change:

Please Login or Register  to view this content.

Hi, you are deviating further from the original topic with subsequent problems/questions.

I suggest closing this thread and opening a new one with your new problem. Fresh threads usually get help faster, and possibly better solutions too.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

If you think that I could be of help, you can PM me a link to your new thread containing the new question, and I will take a look when time permits.