I am coding Excel in VB and have just began to learn how to code through Excel. I can code regular VB, just not in Excel. I need to know how to make the Input box ask for the new name entry and to have it put the text in the appropriate field. I have it working with only one field, but can't figure out the other. It is to be a program for new students which are new every quarter.

ex. - enter new student name and information, put in field. Then bring back same input box, but put name and info. in next field automatically without having to recode each time a new student arrives.

Help