Hey All,
I believe this is a fairly easy problem I am trying to solve, but I'm still in the beginning stages of learning VBA. I created a macro button that places random numbers in 6 assigned boxes. However, I cannot have any repeat numbers. I don't know how to implement the "no repeat" syntax into my code. Any help would be appreciated.
Thank you,
Please Login or Register to view this content.
Brandon
Random.xlsb
You will want to utilize a unique random number generator. Something like this: http://stackoverflow.com/questions/1...bers-using-vba
If you are happy with my response please click the * in the lower left of my post.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you both for your help.
AlphaFrog,
Your code worked great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks