Can this be done

[Guest]

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]

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

 

[Guest]

Wonderful many thanks

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