Excel userforms

HansVogelaar 

Thank you very much👍 I really appreciate it

Just a few more questions...

Do you know how to create a userform on excel that not just opens on the press of a chosen button, but also closes by pressing that very same button, only it's programmed to open the userform when it's closed and closes the userform when it's open?

Additionally, do you know how to make an option on the userform to insert pics onto it?

And also, you kindly showed me how to make it that the userform stores data, the problem with that is that if I change something on it, I don't have the option to cancel it as the userform saves it straight away. Do you know how to make a 'save' and 'cancel' button that influences the data inserted.

And one last thing (until I come up with another problem that I need your expertise for) do you know how to make a macro that repeats the procedure every time I want it to. For instance, if I wanted to make a sheet on shops and I make a shape on excel that opens the userform when clicked on and refers to 'shop 1', and hopefully closes when I click on that shop 1 button if the form is open. do you know how to make it so that if I click on a button, a new shape or cell comes up that refers to 'shop 2' and has it's own userform and stores its data elsewhere and If i were to click it again, it would open 'shop 3' etc. I have included a 'desktop students database template' so you can see what i mean and perhaps infer from it that which I couldn't

Thank you very much