Yahtzee Scorecard - A project

Hi All,

Trying to make a scoresheet for Yahtzee. I've got the basics done, but one thing I really want to do is to have a macro which will ask for how many players and their names and fill in the gaps. I have no idea how to do this.

I've attached what I've done so far.Yahtzee.xlsm

Originally Posted by martindwilson

you forgot bonus yatzee! also why not lay it out just like the yatzee scorecard but instead of game 1,game2 across the top put the players names in there

Yeh, I've been thinking of how to put bonus yahtzee into a formula that will automatically add 100 points if you put 5 in 1s or 10 in 2s etc, if the yahtzee score has already got 50 in it.

I thought that was how scorecards are laid out. I'm doing it from memory, so I could be wrong.

Dom

Originally Posted by Steffen Thomsen

Also forgot pairs.

I think you should look into creating a userform that launches on start up.
Asking for player names.

Yes that sounds right. Is that easy to do?

Dom

Thanks for that, also, what did you mean I'd forgotten pairs?

Ok,

I've created the userform and the code to go with it, and set up the splash screen, but getting an error.

Any ideas?

DomYahtzee.xlsm

Changed it, but still getting 'run time error 9'

Dom

Excellent, got it working now, just need to force it into full screen mode with no toolbars ribbons, or headings. Is there an easy way to do this?

Thanks,

Dom

Also notice that the program fails if less that four names are entered.