Why does my UserForm CheckBox data overwrite my previous data?

  • I have a code written so that when the user clicks submit, their data from the CheckBoxes in the userform should jump in to the next column, with the date as the column header. Unfortunately, it just keeps overwriting the data in the first column and is not adding to it.


    Here is the code I have:

  • Can you attach a copy of your file. De-sensitize it if necessary and explain in detail what you want to do referring to specific cells, rows, columns and sheets.

    You can say "THANK YOU" for help received by clicking the :thumbup: icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!