Create unique random number after hitting command button

Hello,

I have this userform containing a command button. Upon hitting the command button, the code should create a unique (no diplicates) random number. This number is linked to a picture file which is stored in a certain file. This picture opens in a userform. Certain cells are shown in this picture and these can be scored (selection of option in combobox). The correct scores are given in a second excel file (Categorization.xlsx). These scores are checked against the answers chosen in the comboboxes. For the latter, I managed to write a code (see below). However, I don't know how to create unique random numbers. Also, there should be a message when all pictures are scored.
Please find the code below.
Thank you in advance,
Veerle

Please Login or Register  to view this content.

I tried this code, but numbers were not unique...

Then try this one. Original code from http://www.ozgrid.com/VBA/RandomNumbers.htm

Just minor change to make it return array instead of string.

Please Login or Register  to view this content.