Is this possible?????

pauloconnor1985

New Member
Joined
Mar 24, 2018
Messages
1
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!
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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.
 
Upvote 0

Forum statistics

Threads
1,224,760
Messages
6,180,817
Members
452,997
Latest member
gimamabe71

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top