Hello all,
As the title suggests I am hoping to find a decent guide on creating code for a UserForm.
I have created one, I just need the fields to enter the data in an existing worksheet and the command buttons to work lol.
Additionally I was hoping to have a dropdown box in the form to select which worksheet the data is going in.
There are a few other advanced things I'd like the form to do, but am unsure whether it is possible. I'll ask once I have the form entering data in properly.
Attached is a spreadsheet with the userform saved in it. I haven't worked out how to place it in a worksheet, or possible have a macro run when the spreadsheet is opened to automatically open the form. Still learning as I go.
NB: I have removed suburb and last names to ensure privacy is maintained.
As the title suggests I am hoping to find a decent guide on creating code for a UserForm.
I have created one, I just need the fields to enter the data in an existing worksheet and the command buttons to work lol.
Additionally I was hoping to have a dropdown box in the form to select which worksheet the data is going in.
There are a few other advanced things I'd like the form to do, but am unsure whether it is possible. I'll ask once I have the form entering data in properly.
Attached is a spreadsheet with the userform saved in it. I haven't worked out how to place it in a worksheet, or possible have a macro run when the spreadsheet is opened to automatically open the form. Still learning as I go.
NB: I have removed suburb and last names to ensure privacy is maintained.