Coin Toss

[TekWannabe]

I have a small and very simple game in a spreadsheet. I would like t
know how to get around calculations each time a button is pressed.

I would like the heads button and tails button just be a selection an
have the users select another button that actually performs th
calculation.

Also, is there away to show a coin flipping when a button is pressed?

I hope you understand what I am attempting. My file is attached.

Thanks

Attachment filename: tossgame.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63987

 

[Dave R.]

I have a small and very simple game in a spreadsheet. I would like to
know how to get around calculations each time a button is pressed.

"get around calculations"? Can you explain that?

I would like the heads button and tails button just be a selection and
have the users select another button that actually performs the
calculation.

"just be a selection"? "the calculation"?
Hopefully I am not the only one who doesn't understand this part either.

I hope you understand what I am attempting. My file is attached.

Nope, and most people are not going to look at your attachment, especially
if there's clues that there maybe some VBA, buttons, flipping coins, etc. in
there. Please try to explain, using English, what you are trying to do, and
someone maybe able to help.

 

[TekWannabe]

Daannng, that bad huh?

Let me try this again. I am attempting to set up a game that basicall
tosses a coin; there is nothing in the file that flips or turns, I a
just a beginner. Anyway, lets say in:


A1 is "Your Call"
B1: Users input either "t" for tails or "h" for heads.

B1: Coin Toss
B2: =IF(RAND()<0.5,"Heads","Tails")
B3: =IF(OR(AND(B1="h",B2="Heads"),AND(B1="t",B2="Tails")),"Yo
Win","Sorry, You Lose")Sorry, You Lose

F10: Displays the value for B3

I configured buttons called "HEADS & TAILS" associated with B2, so tha
user will click on a button instead of typing a "t" or a "h"; obviousl
I used a macro for the buttons.

The buttons actually perform the calculation instead of having to mayb
click another button to see if they won the toss. I was hoping ther
was a way to do that, maybe not.

Also, was wondering if a graphic or something could be setup t
actually show a coin flipping.

I do hope this clear things up.

Thanks for the response

 

[TekWannabe]

Hopefully I will have something more to show later on. Thanks for al
your responses, you have been a great help

 

[Dave R.]

The buttons actually perform the calculation instead of having to maybe
click another button to see if they won the toss. I was hoping there
was a way to do that, maybe not.

You are saying you want users to have to click another button to see if they
won the toss? 2 ways come to mind;

Use a msgbox popup which shows the contents of B3 in a popup window.

Or if you must use F10, how about formatting B3 so that it's invisible, then
create a new "show the result" code, which would add the formula =B3 into
F10, delay for a few seconds, then delete the cell contents of F10?

Also, was wondering if a graphic or something could be setup to
actually show a coin flipping.

I think an animated gif can be called up, a google group search can help you
here.