Populate an array with unique random numbers

**Kingali** · 04-18-2013, 07:39 AM

Hello everyone,

I'm need to populate an array via VBA with unique numbers between 2 and a number input by users of my form. I've tried searching and to tell the truth got tired. Please help this newbie.

Thanks
Kingali

**MickG** · 04-18-2013, 08:22 AM

Try this :-
The Results are posted to column "C" (via the "Dic.Keys" array) and the Array size is determined by "Textbox1".

Please Login or Register  to view this content.

Regards Mick

**Kingali** · 04-18-2013, 09:27 AM

Hi Mick,
Thanks for the quick reply.
I'm currently testing your code in my VBA form.
I'll let you know how it works.

Regards
Kingali

**Kingali** · 04-18-2013, 11:58 AM

Hi Mick,
your code works great, once I figured out where to subsitute the user inputs.
Thanks for the help.

Regards
Kingali

**Kingali** · 04-18-2013, 12:03 PM

Hi Mick,
Your code works great, once I figured out where to subsitute the user inputs.
This is how I have it working:

Please Login or Register  to view this content.

I guess that if I changed the number "2" then the lower limit will change?

P.S. Moderator i'm not sure how to mark this as solved.

Thanks for the help.

Regards
Kingali