User Form Command Button

.
I created a second user form and it loads as expected.

I suspect your workbook has become corrupted at some point, causing the issue/s you are experiencing now.
My first action would be to delete the existing UserForm1 .... save the workbook and close it.

Then after re-opening the workbook, create a new UserForm1 and try again.

Then I'm doing something wrong with the User form. Is my coding wrong?

Hi.
Your combobox is name wrong in three instances in the initialisation code.
cmbName should be cboName.
Head your code 'Option Explicit' and run 'debug'.

Thank you torachan. That worked. Would you mind looking at the updated version, please? I added the command button and the user box opens but when I click submit it doesn't do anything. I need it to input the data into the table on the right. Again.. Thank you so much for the fix. I was just certified in Excel but I still learning VBA coding.

Hi.
The reason nothing happened was you had named your 'sub' different to your 'command button'.
A few early tips, we all develop different approaches, I can only say what works for me.
First line type 'Option Explicit' this will force undeclared/wrongly named variables to show when you run 'debug'
This can save many hours and headaches trying to work out why code does not run.
When working with UserForm controls (e.g. command buttons)double click on the button, this will place the code ready for you to code.
Similarly when transfering data (from form to sheet)/(sheet to form)use prefix 'Me' this will enable you to correctly id textboxes/combos etc.
I am a big fan of 'Tables' used sensibly they can reduce code and maintenance.
e.g. I have removed your hard coded 'employees' and placed them in a 'Table', all you now have to do is maintain the 'Table' NOT the code.
Hope the alterations are helpful.
happy coding.
torachan.

Thank you!!