BOB? More Craps Help!

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hi Bob,

Thanks for the code, but it doesn't seem to work exactly
as the rules require...

I gave it a test run and for some reason it doesn't work
all the time. Eg. i just ran it and it came up with
8
8
3
6 Lose 1

which should actually continue the chain because you can't
lose on a 6!

just to repeat the rules
a) First Spin Only - you lose on 2, 3 or 12 and win on 7
or 11
b) Any other number continues the chain (i.e. 4, 5, 6, 8,
9 or 10)
c) The only way to then win is to get the same number as
your first spin that continues the chain (i.e. 4, 5, 6, 8,
9 or 10)
d) The only way to lose is to get a 7 before the same
number as your first spin comes up
e) Otherwise the chain just continues until you win or
lose...

Some examples to make it clearer.
Eg.1) 8 (therefore continue) 4, 5, 5, 10, 2, 8 = Win
Eg.2) 5 (therefore continue) 4, 6, 12, 12, 7 = Lose
Eg.3) 3 (therefore stop) = Lose
Eg.4) 11 (therefore stop) = Win
Eg.5) 6 (therefore continue) 2, 2, 5, 11, 6 = Win
Eg.6) 10 (therefore continue) 6, 6, 2, 3, 3, 7 = Lose

Can you see where the error might be?

Please email me at (e-mail address removed)

With thanks
Nick
 
Thanks Bob!

Could you put the code in a reply to this message!

Also what does
Dim cellvalue
do?

Thanks
Nick
 
Back
Top