have you considered using a userform? It may be better if you have multiple
questions. Or maybe just list the questions on a spreadsheet and let them
type into (coloured) cells.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jcody" wrote in message
...
How do you extract and use the data capture by Inputbox functionality?
I'm
developing which solicits data via questions. I am trying to use the data
captured to populate worksheets within the file.