Is there a UserForm creation guide with example VBA code

**zookcruzr** · 2014-07-31, 08:25 AM

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.

**p45cal** · 2014-07-31, 08:03 PM

I see from the userform that you have a date field AND a combobox to choose the sheet; wouldn't it be feasible for the user to enter a date and have the code work out what sheet the data should go into?
I left a response to your other thread - your answer there could impact this thread.
Could you do a little test for me? I've added a DateTime Picker control to the top left of your userform, could you do a 'userform1.show' and try and select a date in the date picker and tell me if it works, what's more it should also enter a date into the date field; does that work too?

**p45cal** · 2014-08-06, 09:29 PM

Could you address this please.

Originally Posted by p45cal

Could you do a little test for me? I've added a DateTime Picker control to the top left of your userform, could you do a 'userform1.show' and try and select a date in the date picker and tell me if it works, what's more it should also enter a date into the date field; does that work too?