Excell VBA Question

I have written a random number generator that will generate between one and ten numbers depending on the users input (in a combobox). this part is working fine. I now need to compare those numbers to a list of employees. the employee numbers are not sequential. So far I can take the generated random numbers and compare them to the array of employee numbers(A column on sheet 2) , and if the numbers match plug the matching number into a cell (C column on sheet 1). I am stuck at trying to loop through the code until I have a match for the amount that the user has chosen.

I would like someone to explain in detail how to do this ( for example, if the user chooses to get 5 employee numbers at random, the code loops through employee number until it matches 5 random numbers) I would also like some advice on how to match the random to the employee numbers without using brute force like I have done. the file is attached.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

XP, 98,NT

Compétences : PHP

en voir plus : work excell, vba work, stuck at work, i need employees now, excell program, excell vba, vba compare, need employees now, excell work, combobox, array random numbers, windows compare file, numbers list generator, vba example code work, generate random number, windows form code generator, random code generator, vba sheet, numbers array program, attached vba

Concernant l'employeur :
( 2 commentaires ) United States

Nº du projet : #2957087

Décerné à:


See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(22 Commentaires)

5 freelance font une offre moyenne de $12 pour ce travail


See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(34 Commentaires)

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(22 Commentaires)

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)