have it store the value somewhere on the sheet?

you could just use

range("a1").value = range("a1").value +1

if the value is already held in the textbox pull it from there and use this

"Office_Novice" wrote:

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.