Determining a Random Value

Summary: If you need to determine a random value in a macro, you can do so using the Rnd function. This tip presents the syntax and usage of the function. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.)

VBA provides a function to return a random value in a macro. While the value of such a function in a word processor is debatable, the function nonetheless exists. The syntax for the function is as follows:

x = Rnd()

where x is the result. The value returned will always be between 0 and 1. To translate this to some other random value, all you need to do is multiply the result by the highest number you want to consider. For instance, if you wanted a random number between 1 and 25, you could use the following code line

x = Int(25 * Rnd()) + 1

Tip #1409 applies to Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Add a Professional Finishing Touch! Word includes great tools that allow you to add professional-grade finishing touches to your documents. You can add indexes, tables of contents, and other special tables by using the detailed information available in this volume.

Check out WordTips: Indexes and Special Tables today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining a Random Value