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

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:

Sub GenProjInfo()
Range ("").Select
ActiveCell.FormulaR1C1 = InputBox ("Input Project Name")
EndSub

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