Have you checked out UserForms? There are many tutorial pages
available and it would be better if you started coding one yourself
and then came back with a specific problem, rather than simply asking
someone to provide the code for you.

http://www.contextures.com/xlUserForm01.html
http://www.exceltip.com/st/Create_Us...Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm


HTH,
JP

On May 12, 2:16*pm, SSW wrote:
Hi - new to VBE & macros, otherwise comfortable with Excel.
I'd like to create a form on sheet1, which will resemble a paper form that
is used to gather info. *I'd like for this info to be entered into a row on
sheet2, and eventually have some totals and other summary info calculated. *
And it'd be great if the operator can click a button for a report - tabular
or even graphic. *Would like all this to be as automatic as possible.
Thanks.