input boxes in Excel VBA to ask a user to enter details and save in every cell

[VBABEGINER]

Hello All,

I want vba code. Ask question using Input box and the type answer should place into cell starting from cell a2, b2 and so on..

input box Q.1. Enter ur first name? … answer of this should go in a2.
input box Q.2. Enter ur last name? … answer of this should go in b2.
input box Q.3. Enter ur age? … answer of this should go in c2.
.
.
.
input box Q.10. Enter ur current city name? … answer of this should go in j2.


If suppose user clicked on cancel button on any question of input box, he/she should prompted the same question again until the value not entered.

Pls advise vba code..

 

[DanteAmor]

A better option would be to use a UserForm, you could add the necessary TextBoxes and until you press a button, the data would go to the sheet: