How to create a form on one sheet that enters data into another

SSW · May 12, 2008

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.

JP · May 12, 2008

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_User_Forms_in_Microsoft_Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm

HTH,
JP

SSW · May 28, 2008

Thanks JP - I've got this one figured out.

JP said:
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_User_Forms_in_Microsoft_Excel/629.html
http://www.ozgrid.com/VBA/UserForms.htm

HTH,
JP

JP · May 28, 2008

Care to share?

--JP

Thanks JP - I've got this one figured out.

SSW · May 29, 2008

Sure.
I searched web and found a link to a site by Ron DeBruin. He has an example
macro that pastes into the next empty row - I couldn't figure out how to do
that.
This gave me enough of a start to figure the rest out.
www.rondebruin.nl/copy1.htm
Thanks again,
SSW