How do I mimic random dice rolls in a sheet

M

Markv

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?
 
B

Bob Phillips

=RANDBETWEEN(1,6)+RANDBETWEEN(1,6)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Markv

Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.
 
B

Bob Phillips

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)
 
M

Markv

Thanks Bob

Bob Phillips said:
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)
Click to expand...
 
Top