I need to create a front sheet for files. when a button is clicked i would
like a series of questions asked and a box to put the answers in so in the
end it all appears on the front sheet.

so if someone clicks create front sheet a box pops up and asks for job ref
with a text box to enter the answer. then on to next question etc.

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html

There's a link at the bottom for more instructions from the MS site.
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

Jonathan wrote:

I need to create a front sheet for files. when a button is clicked i would
like a series of questions asked and a box to put the answers in so in the
end it all appears on the front sheet.

so if someone clicks create front sheet a box pops up and asks for job ref
with a text box to enter the answer. then on to next question etc.

--

Dave Peterson

Wonderful many thanks

"Dave Peterson" wrote:

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlUserForm01.html

There's a link at the bottom for more instructions from the MS site.
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm

Jonathan wrote:

I need to create a front sheet for files. when a button is clicked i would
like a series of questions asked and a box to put the answers in so in the
end it all appears on the front sheet.

so if someone clicks create front sheet a box pops up and asks for job ref
with a text box to enter the answer. then on to next question etc.

--

Dave Peterson