VBA code to Generate 6 Digit ID number

[sn152]

Hi All,

I am trying to generate 6 Digit random ID number.
I referred to the code mentioned in the below link and it generates random ID number.
http://forum.chandoo.org/threads/auto-generate-6-digit-id-number.14578/
But the problem is sometimes it generate 5 digit number. How can I get exactly 6 digit random number? Please help.

 

[vletm]

@sn152
Use Randomize before Rnd (this not help Your challenge)
Do You mean that sometimes You get '5 digit number' like 12345?
But You would like to get only like 123456?
You could also get '1 digit number' like 1.
All those (1, 12345 & 123456) are correct.
Have You tried to 'format' Your r-value, to look like '000000'?
Then it would always looks like '6 digit number' -
beginning zeros matters too.

 

[sn152]

Thanks vletm. That helped.

 

[Marc L]

Hi !

At child level ! Six digit number : from 100 000 to 999 999 …
So Fix(Rnd * 900000) + 100000 !
​