View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
 
Posts: 245
Default Not so Random Numbers

Greetings

I have been using this Me.bxnum.Value = Int((100000000000# * Rnd)
+ 1)
to populate a textbox used to assign a number to a storage box. it works ok.
i would like to know if there is a way to use a number as a starting point
i.e. 501 and the add 1 to that number daily. any ideas? Rather then using
completly random numbers.