What i would like to happen:
1- User clicks a command button and a userform "NewProject" opens - this is working fine. On userform there is a combobox a text box and a command button.
2- User selects a word from a combobox on the userform, then enters text in the text box, then clicks the command button "submit" on userform.
3- Userform closes, focus goes to cell containing matching text from userform combobox on active worksheet and inserts a row just below. Text from userform text box is inserted into cell "C" of new row of active worksheet.

I have been working on this for quite a while now and can seem to get anything working, any help would be greatly appreciated.

Paul