title: Excel VBA Rnd Not Actually Random
body: <p>I currently have a macro that when i click a button, it "randomly" gives me a number in a msgbox:</p>
  
  <pre><code>dim number as double
  number= Int(8 * Rnd + 1) - 1
  MsgBox number
  </code></pre>
  
  <p>The thing is, the numbers aren't actually randomized. For example: If i start the macro, click the button twice, lets say i get the numbers 5 and 2. Now if i close the macro and open it again and click the button twice, i get the same two numbers 5 and 2.</p>
  
  <p>Now i know that in VB.net there was a way to actually get it to spit out random numbers each time without repeating the "sequence" but it's been years since i touched vb.net so i don't quite remember, also i would not know how to use it in excel vba.</p>