PowerPoint Tips Blog

Helping you with presenting, PowerPoint, and speaking

  • Home
  • Blog
  • Tips
  • E-Store
  • Training
  • About
  • Affiliates
  • Advertise
  • Contact
You are here: Home / Delivery / Collect information or feedback

Collect information or feedback

July 15, 2002 by Ellen Finkelstein 6 Comments

READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Have you ever wanted to collect information or get feedback from people who view your PowerPoint presentation on their own? You might have a self-running presentation at a convention or in the lobby of your organization. You could ask them if they liked the presentation and get comments, or you could even collect names and e-mail addresses of people who want more information.

While accomplishing this requires some programming, I recently discovered an article that made it easy enough for a non-programmer like me to get the job done.

The Microsoft Office PowerPoint site has a series of articles on ActiveX controls. Here’s their definition of ActiveX controls:

“ActiveX controls include scroll bars, command buttons, option buttons, toggle buttons, and other controls that you use to create custom programs, dialog boxes, and forms.”

One of the articles is called, “Become a feedback guru using ActiveX controls.”  (Update: Unfortunately, this article is no longer available) This article runs you through the steps to create a slide like this:

Tip: The article doesn’t explain how to change the size of the font. In the Properties box, which the article describes, click the Font item, then click the Ellipsis button that appears. Then you can specify a font, font style, and font size. Another technique that the article doesn’t explain is that you can resize each control, just like you resize any object on a slide.

Viewers can then fill out the survey in slide show view, as you see here:

When they click Submit, they get a thank-you message.

Nice, isn’t it?

The result is a text file, named Survey_results.txt, that is created in the same folder as the presentation. Here’s a sample:

What was unique about this article, in my view, was its clarity and the simplicity of the code. Because it was so simple, I was able to modify it to create a different type of slide, one that collects names and e-mail addresses.

(I have a similar technique in my book, How to Do Everything with Microsoft Office PowerPoint 2003 and 2007, which saves data to an Excel spreadsheet. However the code for that technique is more complex.)

Using the technique in this article, h ere’s what my slide looks like:

Note that my slide doesn’t use any new controls. It uses labels, text boxes, and a button like the original slide, but doesn’t use any option buttons. So I didn’t have to figure out anything new.

Here’s the resulting file (with made-up e-mail addresses:

In order to understand how I did this, you need to read the article that I referenced above. Once you’ve gone through it, look at the code below, which is a modification of the code in the article:

Private Sub CommandButton1_Click()
‘Purpose: Creates a text file and stores the survey results
‘in the text file.

‘You must set a refernce to the Microsoft Scripting Runtime
‘(Tools menu, References command, check the Microsoft Scripting
‘Runtime box, and then click OK).

Dim objFSO As Scripting.FileSystemObject
Dim objTS As Scripting.TextStream

‘Create the text file
Set objFSO = New Scripting.FileSystemObject
Set objTS = objFSO.OpenTextFile(CurDir & “/Survey_results.txt”, ForAppending, True)

‘ Write the results to the text file and then
‘close the file.

objTS.WriteLine “Name = ” & Me.TextBox1.Text
objTS.WriteLine “E-mail address = ” & Me.TextBox2.Text
objTS.WriteLine “E-mail address (verify) = ” & Me.TextBox3.Text
objTS.WriteBlankLines 1
objTS.Close

‘Thank the user.
MsgBox “Thank you. We’ll send you more information shortly.”

‘Clear the results for next time.
Me.TextBox1.Text = “”
Me.TextBox2.Text = “”
Me.TextBox3.Text = “”

‘Return to beginning of presentation for next viewer.
ActivePresentation.SlideShowWindow.View.First
End Sub

The next-to-last line is something I added to move the presentation back to the first slide so the next viewer can start at the beginning, but you don’t need to add this line.

I hope that you can modify this technique for your own situation.

Share
Tweet
Share
+12
Shares 2
READ LATER - DOWNLOAD THIS POST AS PDF >> CLICK HERE <<

Related posts:

  1. Put a presentation on a CD that runs automatically
  2. Use feedback to complete the communication cycle
  3. Add notes in PowerPoint in Slide Show view
  4. Using hyperlinks

Filed Under: Delivery Tagged With: feedback, PowerPoint, presentations, slides

6
Leave a Reply

avatar
This comment form is under antispam protection
5 Comment threads
1 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
4 Comment authors
GregJoshuaEllen FinkelsteinRey Recent comment authors
avatar
This comment form is under antispam protection
  Subscribe  
newest oldest most voted
Notify of
Rey
Guest
Rey

Thank you so much for your insight, I had actually read the article you mentioned before I read your article. Very very useful. I will try and manipulate my presentation to get the same results using these commands. I would like to ask you a question that you might be able to answer, any feedback will be greatly appreciated. I have created a interactive quiz using powerpoint with multiple slides – however I would like to record that information off of the multiple slides. I know the commands in your article are for a single slide, is there a way… Read more »

Vote Up0Vote Down 
9 years ago
Ellen Finkelstein
Guest
Ellen Finkelstein

Rey, you can store information using VBA, the programming code that programs PowerPoint. For more detailed information on creating graded quizzes and sending the grade to the teacher, I suggest David Marcovitz’ book, Powerful PowerPoint for Educators. You can buy it on Amazon.com. On his webpage, you can get some of the code for free

Vote Up0Vote Down 
9 years ago
Joshua
Guest
Joshua

Do you know if it is possible to create an excel file and load the survey data into specific columns? It would make the data collected a little more usable as opposed to a text file.

Vote Up0Vote Down 
8 years ago
Greg
Guest
Greg

The link is no longer working. Where do you add the code? I’m on a deadline. Any help is MUCH appreciated!

Vote Up0Vote Down 
6 years ago
Greg
Guest
Greg

Ok, to edit the code you double click on the CommandButton. But I’m getting syntax error when I test it. ): Any ideas?

Vote Up0Vote Down 
6 years ago
trackback
- Principles of Business Communication and Information - Free Dissertations - Free Dissertations

[…] http://www.ellenfinkelstein.com/pptblog/collect-information-or-feedback/ […]

Vote Up0Vote Down 
2 years ago
wpdiscuz   wpDiscuz

Free Video Training!

13 Techniques that Will Make Designing Your Slides EASY!

And get the PowerPoint Tips Newsletter with tips and resources for presenters. Plus 5 bonus tips!

BirdSend Email Marketing Tool
4-up-ads PresenterMedia PoweredTemplate High-Persuasion Secrets Power Pointers Quarter Hour


Recent Posts

Recent Posts

  • Using PowerPoint’s cartoon people
  • Which version of PowerPoint should you buy?
  • Add a customizable, live web feed with Cameo
  • Get a designer look with abstract images to create backgrounds for slides and shapes
  • Creating and using a strong call-to-action slide

Connect with me!

Connect with me! Twitter LinkedIn Facebook

Ellen Finkelstein, Inc. · Fairfield, IA · Tel: 515-989-1832

Privacy, Refund, and Other Legal Stuff

wpDiscuz