Dear Forum Experts,

I have used the below given code in order to get auto populate value from define index list from worksheet. The logic is .. if i select a value from combo box, i will get auto populate value in next two fields in user form.

combo box value has a list of names, and next field is auto populate and its a text box. If i select names, "message box comes for ensuring the name" and then automatically next text box receives value their Code Number. i am fine till now.

Now the problem is, some of the person has a similar name, but their code number is different. here i am not able to stop and select the name, which i want. even if i click 'OK" in message box, the next name comes.

My requirement is, among the multiple person with same name, i want to stop, confirm and select the person with his respective code number. 






Please Login or Register  to view this content.