Use input box to fill cells?

[David Sizemore]

My question may be quite simple, but I have not been able to find any
info on it (due, no doubt to ignorance)
I want to use the info from an input box to fill certain cells,
basically prompting the user for the info to populate the cells.
Let's say that I want to put customer names in A8-A100. How can this
be written to allow the user to have this info put in, be able to exit
at any point, and possibly insert cells if they go beyond the range
stated above?

Thanks

 

[Dave Peterson]

Maybe you could select the range, then do data|form?