<div>
See the other answer. <a href="http://www.pptalchemy.co.uk/Random_Choice.html" rel="ugc">The code is easily adapted to do this</a>
</div>


See the other answer. The code is easily adapted to do this [http://www.pptalchemy.co.uk/Random_Choice.html]

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
In VBA, how can I obtain 5 random numbers from a range. Lets say the range is 1-50, I want to get 5 numbers at random from this range and each number picked must only occur once.<br />
<br />
4, 45, 23, 16, 12 = ok<br />
<br />
4, 45, 12, 23, 12 = not ok as 12 is repeated<br />
<br />
Thanks
</div>
</div>


Hello

In VBA, how can I obtain 5 random numbers from a range. Lets say the range is 1-50, I want to get 5 numbers at random from this range and each number picked must only occur once.

4, 45, 23, 16, 12 = ok

4, 45, 12, 23, 12 = not ok as 12 is repeated

Thanks

Powerpoint 2003 VBA - obtaining 5 random numbers

PowerPoint is a slide show presentation program currently developed by Microsoft. PowerPoint presentations consist of a number of individual pages or "slides" that may contain text, graphics, sound, movies, and other objects, which may be arranged freely. The presentation can be printed, displayed live on a computer, or navigated through at the command of the presenter. Slides can also form the basis of webcasts.