Create Macro Asking Input Information for Existing Database & Want to Print out form

**CEL2013** · 02-22-2013, 05:57 PM

Hi!

I am both new to the Forum and to writing macros in Excel. I have an existing database for which I need to write macros asking questions so users can input information into the database. After inputting the information, we want to see the results in the database and we want to print it out. I have tried to create a macro for some of the questions. An example follows:

Please Login or Register  to view this content.

This allows me to ask the question, but it does not fill in the information in the database. How do I get it so I can see the information populating the database cells? Also, how do I print out the resulting form?

Any assistance you can provide will be GREATLY appreciated! Thank you so much!

Colleen

**JBeaucaire** · 02-23-2013, 06:18 AM

Here's a basic way to do it. Just add questions for each column you wish to collect. The macro will loop so you can enter multiple rows of data, then offer to print the sheet when done.

You willl need to edit the sheet name:

Please Login or Register  to view this content.

Obviously this is print out a row-based database sheet. If your form is more of an actual FORM, then remove the NR stuff and enter the exact cell addresses where you want to enter the values since those WON'T be variable.

**CEL2013** · 02-23-2013, 02:09 PM

Jerry,

Thank you so much for your assistance! I will try it immediately! Thanks, again!

Colleen

**JBeaucaire** · 02-24-2013, 11:43 AM

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

Create Macro Asking Input Information for Existing Database & Want to Print out form

LinkBack

Thread Tools

Rate This Thread

Display

Create Macro Asking Input Information for Existing Database & Want to Print out form

Re: Create Macro Asking Input Information for Existing Database & Want to Print out form

Re: Create Macro Asking Input Information for Existing Database & Want to Print out form

Re: Create Macro Asking Input Information for Existing Database & Want to Print out form

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions