Copy Data From Userform Textboxes to Sheet

Hi

I have created a user form, with text boxes to capture certain information. This data then needs copying & pasting to another sheet with headers that match the captured data. The user form will be used daily so will always need to paste to the next empty row on sheet 1. I would only want data to submit when i hit the control button I have created in bottom right corner of the form.

I have read that you can reference in the properties of the text box to a linked cell but I cannot seem to find this anywhere. Is there another way of doing this using code?


There are also 4 tick boxes to get a yes/no answer. How do i get the relevant tick box to put a yes/no answer in the correct column on sheet 1? ( Columns H & I for reference)


I have attached the sheet for reference.

Thanks
Mark

Database.xlsm

Here is the basic approach (left some for you to do to learn).

I would use either a combo box or option buttons in place of the check boxes. I've showed how to use a combo box. Check boxes should be reserved for "yes" or "no" choices (you had the right idea with text) and option buttons or combo boxes used to provide unique selections.

Note: The "Yes" / "No" selections for the combo box are being added when the form is loaded.

Please Login or Register  to view this content.

kym1901,

The code you provide does a lot of unnecessary cell activating/selecting/progressive offsetting which is generally not required when using VBA. It also depends on Sheet1 being the active sheet when the user form in invoked - something the OP may not want (seeing as the original WB has other sheets). It is not uncommon to show an input form and keep the data table hidden from users (thought OP doesn't specify this).

As the code is currently written, both yes and no check boxes may be ticked and this will create an error (code may not fault, but the wrong value may be written to the cell), thus the reason for using either option buttons or combo boxes, list boxes (depending on the number of selectable options required).

Thank you, Palmetto, I am changing my code. I have just started teaching myself and built a couple of forms. What you showed makes it much simpler.
Cheers.