Pushing Buttons to Create a Rubric for Students

BrockYoung · #1 02-14-2016, 03:22 AM

Greetings all,

I've been watching YouTube tutorials and reading up on VBA to solve this problem of mine. I'm a teacher in Canada, and I wanted to create a fillable PDF that my students could use to build their own marking rubrics. In Ontario, we use four different sections to mark students (Knowledge, Thinking, Application, Communication). I want my students to have choice for final unit projects (Write a paper, make a portfolio, write a kid's book, etc), and to do that, I want them to be able to make their own rubrics.

In the attachment, you'll see what I mean. On Page 1, under Knowledge, you'll see button one. If the student clicks that button, I want that box's content ("I will identify..." to be pasted into the knowledge box on page 2. You'll see where I'd like it to go. If I can get that to work, I will make buttons for all the options on page 1 to go to the right place on page 2.

Can anyone help me out?

Thanks!

Brock

macropod · #2 02-14-2016, 03:37 AM

You cannot create fillable PDFs using Word. You'd need Adobe Acrobat Pro or an equivalent application for that.

BrockYoung · #3 02-14-2016, 03:45 AM

Thank you for the quick reply!

macropod · #4 02-14-2016, 05:26 AM

FWIW, you could use a Word document such as the one you've already created for this. For example, if you add the following code to the document and save it in the doc or docm format, you could use the following code with your existing button:

Code:

Private Sub CommandButton1_Click()
Dim Rng As Range
Set Rng = Selection.Cells(1).Range
With Rng
  .End = .Paragraphs.Last.Range.Start - 1
  While .Characters.Last.Text = vbCr
    .End = .End - 1
  Wend
  ActiveDocument.Tables(2).Cell(2, 2).Range.Text = .Text
End With
End Sub

Simply add the code to the document's 'ThisDocument' VBA code module.

Do note that users will need to enable macros for the button to work.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Free Office for Students - Subscription?	temporary_user	Office	1	01-06-2015 03:34 AM
Deleting rows & pushing them up causing issues	ep2002	Excel	2	08-29-2014 02:09 AM
Students Cheating	jaw19883	Word	9	04-04-2014 06:14 PM
Re-installation of MS Office for Home and students	Roshan Hanief	Word	2	06-09-2011 09:40 AM
How to Create a Locked Sequence of Buttons	kcackin	PowerPoint	0	01-24-2011 02:43 PM