How do I mimic random dice rolls in a sheet
Thanks Bob
"Bob Phillips" wrote:
Just drag a button from the forms toolbar and assign a simple macro
Sub Recalc
Activesheet.Calculate
End Sub
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Markv" wrote in message
...
Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.
"Mike H" wrote:
Hi,
Put this in 2 cells
=RANDBETWEEN(1,6)
Tap F9 to roll the dice again
Mike
"Markv" wrote:
I have created a virtual business project on a xcell sheet and require
some
help on how to mimic values rolled from 2 dies.
ie. manually casting two real game dies and both the values are random.
I want the above to reflect on a sheet upon pressing a button.
Can anyone help?
|