Look up the Rnd function in help. However the biggest positive number that an
integer can be is 32767 so you won't be able to get a 10 digit number into an
integer.
I have some vague memory of reading something somewhere, that the # in this
context means that the number is too big for VBA to store precisely, and
that it will be approximated ... or something like that ... sorry, like I
said, just a vague memory.
--
Brendan Reynolds (MVP)
Bill H. said:
interesting... I also had the editor insert that "#" for me, yet when I
had
only 9 digits, the "#" was not inserted.
Me.Text0 = 0
Me.TimerInterval = 0
Do While Me.Text0 >= 0
For i = 1 To 200 Step 1
If Me.TimerInterval > 0 Then Exit Sub
Me.Text0 = Int(Rnd(1) * 10000000000# + 1)
Call BaseTimer(50)
Next
Loo
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.