| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a form on one sheet that enters data into another
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create a form on one sheet that enters data into another
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create a form on one sheet that enters data into anothe
Thanks JP - I've got this one figured out.
"JP" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create a form on one sheet that enters data into anothe
Care to share?
--JP On May 28, 3:23*pm, SSW wrote: Thanks JP - I've got this one figured out. "JP" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create a form on one sheet that enters data into anothe
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 "JP" wrote: Care to share? --JP On May 28, 3:23 pm, SSW wrote: Thanks JP - I've got this one figured out. "JP" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| two questions, Yes/No form control, and how did they create this adjustable area on the sheet... | Excel Worksheet Functions | |||
| Create a form in excel so I can enter data using DataForm | Excel Discussion (Misc queries) | |||
| Can I create an entry form that will feed a data sheet | Excel Worksheet Functions | |||
| how to get a data form to fill you own exel sheet (was data-form | Excel Worksheet Functions | |||
| I need a form to create pay stubs from a payroll data sheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
