Saving Userform Data

  • I have, what I think is a fairly simple question:

    I have created a userform with 6 textboxes and one combobox. At the moment everything works perfectly, however, I would like to change the location the data is saved to.

    At the moment, the data is saved to the first available cell in the upper right hand corner of the spreadsheet. However, I would like to save the data to a specific location on a different hidden worksheet. The purpose of this is to prevent access to the data table by the end user.

    Hopefully, someone has an easy answer to this question. I have included the relevant code below


  • Which sheet and what is the "specific location"? ;)

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • I think this is what you want

Participate now!

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