Generate ClientID

Hello,

I have a UserForm and i wanted to know if there is a VBA code i can use to generate a 5 to 8 digit number without repeating. I want to be able to assign my clients a unique number.

Attachment 654298

this is my UserForm

.
To attach your project to your post, click on GO ADVANCED which is located in the lower right or where you REPLY TO THREAD.

In the next screen, below your post, select MANAGE ATTACHMENTS.

this is what im working on ans Sara thank you for the code. It works but i cant find where i made a mistake in the code i use and adding the code you posted above

Another approach to consider.
Based upon similar method that small accounting packages adopt (part customer name id + serial number).
Presently set as (first initial + surname initial + random number (01 to 99))
To 'ADD' a new entry, first 'CLEAR' form then press 'NEW' to add your detail to DataTable, the rest should be self explanatory.
torachan.

Thanks Torachan and saravnepali...you guys really helped me out a lot!!!