Please help with code
Posted: Tue Aug 28, 2012 11:57 pm
Hello I have built this but need to know a way to add a user to the draw I can add them to the list view with all the info but any how it works
For example, let's pretend I have a 10-slot lottery. I would write the entries as follows:
foxilvery 2 #3
supersilver 3 #1
chimmy 4 #3
toby 1 #4
I use an excel function that would basically do this:
foxilvery 3
foxilvery 3
supersilver 1
supersilver 1
supersilver 1
chimmy 3
chimmy 3
chimmy 3
chimmy 3
toby 4
All those numbers combined = 25. So, I would count along that listbox to #25. In this case, Supersilver's last ticket would win. Second place would belong to Toby.
soo how can I do this in code here is my form

For example, let's pretend I have a 10-slot lottery. I would write the entries as follows:
foxilvery 2 #3
supersilver 3 #1
chimmy 4 #3
toby 1 #4
I use an excel function that would basically do this:
foxilvery 3
foxilvery 3
supersilver 1
supersilver 1
supersilver 1
chimmy 3
chimmy 3
chimmy 3
chimmy 3
toby 4
All those numbers combined = 25. So, I would count along that listbox to #25. In this case, Supersilver's last ticket would win. Second place would belong to Toby.
soo how can I do this in code here is my form
