VBA using Loop

[lela0643]

Exercise 12: Find a student
Open the workbook "Résultats examen.xlsx". In the first spreadsheet (Results) you have a list of students.
1) Build a VBA macro that asks the user with a dialog box, the name of the student to find. This macro will browse the list and select the cell corresponding to the name of the student.
2) The macro informs the user, with a second dialog box, if the student has been received.
3) If all the list has been explored and the name has not been found, the macro displays the message “student not found in the list” and select the first empty cell below the names list.

Help please?

 

[Jimmypop]

now I was able to make it work, thank you so much!!
How can I make a macro that informs the user, with a second dialog box, if the student has been received?

And another quick question what do the functions StrPtr and Chr do? I am not familiar with those and was wondering wheter they can be replaced by a more simple way?

Glad you got it to work... I am going offline now and will answer soonest... In the meantime if someone else is reading this thread they can provide clarity as well