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

Take Control! Master the real power behind Word! Successfully master the secrets of powerful formatting and create documents that stand out from the rest. Best of all, you can create documents that are easy to maintain and quick to change.

Check out WordTips: Styles and Templates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining a Random Value