VBA in EXCEL

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

Pls post your code.

The code to write into fixed locations is easy, what you need is something that takes care of "where to put " the next.
Some consdiderations:
At the start, will the "writing" always start at the same spot? (If not, you need to search for the first free cell in the column or row)
To put the next value into a folowing cell, either search for the next free cell or count your inputs and use this counter to write into the correct cell!