Have a look in vba help index for INPUTBOX

--
Don Guillett
SalesAid Software

"Deepak Varde" <Deepak wrote in message
...
Hello, I want to be able to have rows/cells generated with a certain text
based on the answer given by a user.
For example, My question in a cell could be "how many groups have you
made?".
Now to this if the user answers "3" then I would want three cells below to
ask "what is the name of your first group", "what is the name of your
second
group" and so on. Based on this further questions could be asked.