42320135
11-20-2011, 07:29 PM
Dear Guru
I have a project
In December our company will to have New year party.
I have requirement from staff.
need to make program random employee ID number for receive prize
But I don't know how to, If possible if someone have a code use by VBA could you please advice me.
Becuase I don't have any expernince for EXCEL VBA
< Concept >
1. Make Sheet1 to keep ID number and Name.
2. Sheet2 to make button on click to random ID Number from sheet1
3. Random Timing 10 second
4. When random fininsh show ID number and Name in sheet2
(if ID number already receive prize 1 time status show " You already receive or ID Number is duplicate ")
Could you please help
Becuase I don't have any experince for make it.
Thank you for all help me
Regards
I have a project
In December our company will to have New year party.
I have requirement from staff.
need to make program random employee ID number for receive prize
But I don't know how to, If possible if someone have a code use by VBA could you please advice me.
Becuase I don't have any expernince for EXCEL VBA
< Concept >
1. Make Sheet1 to keep ID number and Name.
2. Sheet2 to make button on click to random ID Number from sheet1
3. Random Timing 10 second
4. When random fininsh show ID number and Name in sheet2
(if ID number already receive prize 1 time status show " You already receive or ID Number is duplicate ")
Could you please help
Becuase I don't have any experince for make it.
Thank you for all help me
Regards