VBA Submit Error

Hi Guys,

I currently have VBA running so when the submit button is pressed the data will transfer to another tab.

This is working and I have error messages when there is data missing. An error box comes up for the corresponding ComboBox when the user presses submit.

Let's say there's data in 4 out of the 5 text box's when I press submit the error box comes up fine but the data is submitted to the spreadsheet, how do I stop this from happening??

Also when the userform is run, it seems to start at date, how do I get it to start at name instead?

I've included the code below and also attached the spreadsheet.

Thanks in advance everyone!!!

Please Login or Register  to view this content.

Hi Frank,


To get your Name highlighted at the beginning, please paste this formula. (the check should be on top)

Formula:

Please Login or Register  to view this content.

And To stop Macro pasting the data when the date is wrong.

Formula:

Please Login or Register  to view this content.

Cheers.
Lex

Hi Lex,

Thanks for getting back to me and the top VBA works perfectly so thanks.

The second part, I've put in place of the existing code I have but it doesn't seem to be working.

If I haven't been clear enough I apologise, but if any data is missing the data that is there shouldn't be submitted.

Hope this helps, thanks again.

Hi Frank,

Please see file attached. If any of these variables e.g. name, Date, Team, Division, Action are missing. The macro will stop and force user to fill it in again.

Thanks
Lex

Hi Lex,

Thanks for getting back to me so quickly.

What you've attached is arranged differently but it works perfectly.

Thanks for helping me out and attaching the spreadsheet.

Reputation added for you my friend!!!!

Thanks

Frank

HI Frank

No worries. Glad to Help

Lex