UserForm Checkbox populate last empty row of range

Greetings guys!

Hope you can help me out on this one!

I have a spreadsheet with a Userform with many checkboxes and textbox.

Upon the click of the submit button, I would like the checkbox values as well as the texbox values to populate the last empty cell in their respective ranges.

For example:
If Checkbox1 is checked, then I'd like it to return the value "Y-Cording" in the the first available empty cell in range E.
If there is text entered in Textbox1 then i'd like it to return the entered text in the first available empty cell in range Z..etc..

Please note that the data needs to be input starting at row 4

Thanks guys

can you post the worksheet with the userform and example of where you want the data?

what do you want to be placed in the sheet? just a check mark or a 1 or 0 or what?

Hey!

A checkmark would be good enough..just for the part where it says type of monitoring i would prefer it would be whatevers intitled "Y-cording","remote" etc...

Thanks again

Hey Krabine,

I pretty much figured this one out. Everything is functionning correctly.

The only thing I'm missing is: When the user clicks on the submit button in the UserForm, I want a macro to check to see if there are any OptionButtons that are not selected. I realise I can do this whith a IF value = False but the problem I'm encountering is that my OptionButtons are currently grouped. So how do I apply a macro for the grouped buttons ?

I've tried assigning a control source for each of them and from there on I have an OR formula in a cell that checks if any of the values is = True.. But that is causing a little issue with my OptionButtons as it's changing their format to Greyed out dot with a white background. Funny thing is, once I do that, and then remove the ControlSource, it's not going back to it's original format..Weird.

Any other solutions to this ?