Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A 2 fold macro question. *(I need some MVP help on this one.)
1)
Dim nPlayers As Variant Dim nPlayer As Long Dim nRounds As Long Dim nTurns As Long Do nPlayers = Application.InputBox( _ Prompt:="How many players (1 to 4)?", _ Default:=4, _ Type:=1) If nPlayers = Cancel Then Exit Sub 'clicked Cancel Loop Until nPlayers 0 And nPlayers <= 4 For nRounds = 1 to 13 For nTurns = 1 to 3 For nPlayer = 1 to nPlayers MsgBox "Now up: Player " & nPlayer 'Do stuff 'end player's turn Next nPlayer Next nTurns Next nRounds 2) I would probably use a Userform for this, that displays the results of the roll, along with option buttons for where to store the results of a roll. In article , "Pete" wrote: 1) My first dilemma is I do not know how to make the spreadsheet recognize whose turn it is. I need something that says after a Player 1 has recorded his/her score clear dice and announce it is Players 2 turn and so on. But if there are only 2 Players then after Player 2 records there score then it is Players 1 turn again. And so on for any combination of the number of players that are in the game. 2) My second dilemma is when the Player is happy with there dice then I want to be able to give them the ability to Record there score in the appropriate box they see fit. What I in vision is a button that is linked to a macro that looks at the outcome of the dice and which players turn it is and populates the outcome or total of the dice in the proper box. Keep in mind the outcome of the dice could be anything from a Full house (6-6-6-5-5), to random numbers of anything (1-3-5-2-2) and you have to choose whether to take the total score of the dice ("Chance") or put 1 in the ("1's box) or 4 in the (2's box). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read fold contents | Excel Discussion (Misc queries) | |||
two-fold problem | Excel Discussion (Misc queries) | |||
Fold / unfold without subtotals function | Excel Worksheet Functions | |||
fold change lines | Charts and Charting in Excel | |||
A 2 fold macro question. *(I need some MVP help on this one.) | Excel Programming |