VBA Randomize Statement
Randomize Description
Used to change the seed value used by the random number generator for the Rnd function.
Simple Randomize Examples
Sub Randomize_Example()
Dim randomValue
Randomize
randomValue = Rnd
End Sub
Randomize Syntax
In the VBA Editor, you can type “Randomize(” to see the syntax for the Randomize statement:
The Randomize statement contains an argument:
Number: [Optional] It is a numeric “seed” that will be used by the Rnd function to generate a random number.
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!