Is this possible?????

[pauloconnor1985]

Hi Guys.
I want to run something past you to see if this is possible.
I want to create a form that has locations (cells) for me to type data into (Names, address info etc.).
I also want to have a section full of check boxes within the form that when clicked, inserts a box of pre-written info from a separate page or database. i want to be able to click say 20 boxes and the same amount of boxes populate under the above form.
Then be able to print it out.

Does anyone know if this is do-able in excel? Or even a combo on Excel and Access?
I'm sure I did something like this in school but 20 years have passed and I haven't got a clue where to start.
Thanks in advance!

 

[spiralrain]

If I'm understanding this correctly, then yes, it is possible.
Create your form in excel on a sheet (we'll call Form1).
At this point you should be able to type in whatever you want and print the form.
Now on the developer tab, click insert and choose the active control check box. You can create as many of these as you want.
on another sheet (we'll call data), put the pre-written info you want placed in Form1.
Now go back to Form1 and in the developer tab and click design mode. With design mode on, you can right click the check box and format it to not print. You can also bring up the code attached to it (it'll be empty to start) and write the code to move the pre-written information from the data sheet over to the proper place in sheet Form1. Something like:

If CheckBox1 = True then
Sheets("Form1").Range("B4") = Sheets("data").Range("A1")
Sheets("Form1").Range("D4") = Sheets("data").Range("A2")
Else
Sheets("Form1").Range("B4") = ""
Sheets("Form1").Range("D4") = ""
End if

I hope I understood correctly and that this helps.