How to code the submit button?

[Sableye]

Hi, I am making a form in excel I have attached. The first page is dummy info and not confidential. I created a form out of the objects on sheet 3 and then had them route to sheet 4as a 'backend' before going to the main sheet (I still need to do this). But I have no idea how to code the command button to be able to re-enter information. I looked online and know I need to make it so where it outputs goes down a row but none of my tries have worked.

[Sableye]

Let me know if it doesn't work or what I could do.

[Logit]

.
Study this example of a basic database using a USER FORM rather than the worksheet to enter data.

Please Login or Register  to view this content.

[Sableye]

.
Study this example of a basic database using a USER FORM rather than the worksheet to enter data.

Please Login or Register  to view this content.

Thank you so much for replying. I have attached where I tried to code a forum in vba but the radios got connected and it didn;t work, then I tried switch to what I posted in the original. Could you look at the forum I coded in vba and let me know how to fix that then? Please let me know what I should do next I am very desperate about this. Also let me know if I need to upload the code sepretley.

[Logit]

.

Please Login or Register  to view this content.

Resource URL : https://thedatalabs.org/userform-and...uttons-in-vba/

See attachhed

[Sableye]

Thank you for this resource, Can you explain why my code didn't work? Do you need to send it separate?

[Sableye]

.





See attachhed

Please Login or Register  to view this content.

Here is that section of my code.

[Sableye]

Do I need to redo the option button parts only?

[torachan]

you have your option button submit code on UserForm-Click event this code should be on command button Submit_Click event.
Also look at @ Logit's submission - look at the option button properties - each set is placed in a group - this separates each set so that multiple group choices can be made.
torachan.

[torachan]

Give the attached a run through.
With pre-planning it is possible to condense your code by grouping controls by adjusting their name so that you can cycle through them.
torachan.

[Sableye]

Thank you sososo so much, you dont know how much this helped. I am going through it all and understanding the errors.