Userform question about IF w/outputs on multiple lines

Only the first guy checked comes out on the list.
All players that we're checked need to get listed.

Any takers before it gets thrown to page 2?

It's a box that states if a player was present.
I list all possible players (I could use 2 comboboxs instead of ticking who was present).

So team 1 was comprised of : check box of players present
team 2 was comprised of: check box of player present (boxandre2, and so forth)


In sheets "résultats" I'll have points for and points against ("score2" if player was in team 1, or "Score1" if player was in team 2).

Good look on this:

Please Login or Register  to view this content.

to get names without typing.

But the whole coding as suggested returns on 1 row:
the calendar date, the first name on the list, score1, score2
And then all the following rows have somebody's name in colomne B.

So not a success right now.

We're getting there.
look at the first post, it contains the xlsm file.

Last post you did brought back:
calendar1, "xandr", Score1, Score2
calendar1, "xsimo", Score1, Score2

And so forth for all checkboxes.


I'm only strggling with empty rows here. I've tried with comboboxes instead and it's the same thing:

My last if statement looks for an empty row, but it's as if the if statement before had not populated the last empty row, so the whole sub sees only 1 emptyrow, the first one that was available when the first if statement started.

Wow that does great. I just need to add an if to set team2's "opponent" score, or the score agains to be score1, and their core to be score2.

Now team 2 has the same score as team1.

Thanks a bun. I'll try to drill through to understand the logic behind the coding. very usefull

I tried to add an if Name (Ctrl) = "*1"
to check for theam 1.
that doesn't work it seems.

Please Login or Register  to view this content.

It said number of arguments incorrect or invalid property.
(it's in french, I'm not 100% sure how to translate)

Everytime I come on here, I get the most amazing help. Remember, this is tennis scores. I'm on work hours, and I shouldn't even be doing this.

it's good knowledge to apply afterwards, but it's still tennis scores...

I'm still stuck. I don'T know what object to use to check for the checkbox name having a 1 or a 2 in it.

Only one player can partake in the score, we play doubles

Ah, I'll probably just keep the version where I select lastrow, and do +1, +2, +3 to combobox, even if this leaves blanks, I'll live with it, we almost never play singles anyways.