How do I mimic random dice rolls in a sheet

  • Thread starter Thread starter Markv
  • Start date Start date
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?
 
=RANDBETWEEN(1,6)+RANDBETWEEN(1,6)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks Mike, Bob It works, can this work with a button in the sheet ie.
"Press to Roll"?
If so can you assist.
 
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)
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dice roll "problem" 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Accessing the value in a cell of a sheet of variable name 6
How do I change column data based on dynamic (rolling) dates? 1
Auto-Assigning a (random) Name from list of values 2
Building closed workbook file path within an Index Function 6
Automatic rolling months for forecast sheet 7
How can I get a macro to opperate from a different sheet 3

Back
Top