Remember Me?

#1
January 4th 05, 03:34 PM
 Greegan Posts: n/a
Random Number Questions

I hope my explanation below makes sense and that someone will be able to
help me out.

I want to have a worksheet that chooses a random number. The thing is, this
number represents a particular "playing card". This is for a board game my
friends and I have decided to try online...
So this playing card is repeated 5 times in a deck of 40.
What I would like to do is have numbers 1-5 represent the same playing card,
6-10 another, and so on.
I want to click a button on the worksheet, have it generate the number,
which draws the card and then not have that number repeat itself until I
"shuffle" or reset the deck with another button.
Now I have seen how the random number can be generated, and if I'm correct
the number will randomly select another number if a field is double-clicked
or F9(?) is selected...
I want to avoid the double click and F9. I would like to have it choose that
"playing card" and be able to continue with the "drawing" of cards until
they are all used or I reset the deck.

Could anyone assist me with this?

Much appreciated.

G

#2
January 5th 05, 02:00 AM
 Dave Peterson Posts: n/a

I'm not quite sure how you populate your range (or when), but you may want to
look at JE McGimpsey's routine for non-duplicated random numbers.

You can find it he

http://www.mcgimpsey.com/excel/udfs/randint.html

Greegan wrote:

I hope my explanation below makes sense and that someone will be able to
help me out.

I want to have a worksheet that chooses a random number. The thing is, this
number represents a particular "playing card". This is for a board game my
friends and I have decided to try online...
So this playing card is repeated 5 times in a deck of 40.
What I would like to do is have numbers 1-5 represent the same playing card,
6-10 another, and so on.
I want to click a button on the worksheet, have it generate the number,
which draws the card and then not have that number repeat itself until I
"shuffle" or reset the deck with another button.
Now I have seen how the random number can be generated, and if I'm correct
the number will randomly select another number if a field is double-clicked
or F9(?) is selected...
I want to avoid the double click and F9. I would like to have it choose that
"playing card" and be able to continue with the "drawing" of cards until
they are all used or I reset the deck.

Could anyone assist me with this?

Much appreciated.

G

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TXlimogirl Excel Worksheet Functions 5 November 6th 12 10:38 PM Markw3700 Excel Discussion (Misc queries) 1 January 21st 05 12:37 AM Philippe L. Balmanno Excel Worksheet Functions 4 December 17th 04 07:42 AM darebo Excel Discussion (Misc queries) 2 December 6th 04 05:01 PM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM

All times are GMT +1. The time now is 06:55 AM.