Hi, I am new to this and this is probably very simple but I am trying to setup a userform with multiple combo boxes and text boxes. I have the form setup and it is working fine except for one thing.
The form has a league combobox and if you pick the league it then goes to Date (input date from calendar). Once the league has been chosen you then go to home or away teams and it will give you a drop down of teams for that league. The scores are also combo boxes with 0-9. This all works fine but if I only want to add in say 4 match results for that week the form populates my sheet with 4 scores but 12 dates.
e.g.
28/10/2013 Team A 1 Team B 1
28/10/2013 Team C 1 Team D 0
28/10/2013 Team E 3 Team F 2
28/10/2013 Team G 0 Team H 2
28/10/2013
28/10/2013
28/10/2013
28/10/2013
28/10/2013
28/10/2013
28/10/2013
28/10/2013
My question is how can I add in say just 4 match results and only populate the spreadsheet with those 4 scores so it stops adding in the additional 8 lines with just the dates. Code for this form is below.
Any help would be greatly appreciated.
-----------------------------------------------------------------
Bookmarks