Hi.
Excel-beginner here. I'd like to know if it's possible to create a VBA form (stand-alone or inside an excel-document doesn't matter for me)
that saves all the input data into it's own sheet. The sheet should be saved with the same name provided in the textfield "Name" in the form.
I hope you understand my explanations. After each click on the "Save" button in the form, the form should go blank again and next time you
use it the form creates a new sheet, filling the Excel-document with new ones every time.
Is this possible? Can you please point me to any good tutorials. I've googled and found some tutorials about creating a VBA form but none
that present the possibility to add a function that creates a new sheet inside the same document.
I haven't got much experience in VB programming but have seen some code and it doesn't look that hard to understand.
EDIT:
The purpose of this is to be able to customize the form-fields and making it easier/faster
to enter information about certain projects. Also to be able to return and add more info/pictures/
calculations later on, in each "project" (sheet).
That's why I want every project to be saved in the same Excel-book. But if anyone have other ideas
how to pursue this (outside of Excel) I'd be glad to hear them
Very nice forum btw! :-)
Thanks in advance for your expertise!
Bookmarks