This is very easily done.
Are your inputs Textboxes? Comboboxes? ListBoxes?
The best idea is to create your textboxes sequentially so you can tab between them in sequence.
Then you can use a loop to save your text boxes rather than saving each in turn.
If there is a lot of data, Read your userform data into an array and save that array to excel
This will speed up your data entry quite dramatically.
I'll post some code to show you how to save your Userform.
Please note i use the first Line of My DataSheet as the default text for my userforms.
Ex TextBox 1 contains "First Name" until you click on it at which point my textbox enter event clears it, but is you save the entry without changing the first name,
textbox1 will have the same text as cell A1 I " First Name" and so I do not save it.
Bookmarks