Hi,

i have created a user form to log incoming calls. Basically the user form pops up when the file is opened, you enter data into the fields and click...log...then i logs the data on the sheet behind.

Is there a way that on the actuall user form, every time a blank form appears a random number appears that can be used as a reference....this number cannot be the same as one already used though...

any ideas??

thanks in advance