 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / September 2007formula/equation over multiple PP slides
Hi, I need help! I am trying to insert a simple formula/equation into a PP presentation. The idea is that there are 2 slides, the first 2 will include a fill in box for the presenter to input on presentation, and the slide following will calculate the formula needed (on click)using the data from what the presenter inputs. If this makes any sense, and you can help me, please do! This is going to require some VBA. First, you will need a way to enter information onto a slide. This can be done with a control textbox, or it can be done with the InputBox function of VBA. See: Adding or entering text during a show http://www.pptfaq.com/FAQ00701.htm Next, you will need to calculate the answer and display it on the next slide. This is not too difficult if you know any VBA. I have examples of using information input during the show on a slide at my site: http://www.PowerfulPowerPoint.com/ Example 6.6 is the first example that does this on my site. --David  SignatureDavid M. Marcovitz Microsoft PowerPoint MVP Director of Graduate Programs in Educational Technology Loyola College in Maryland Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ > Hi, I need help! > I am trying to insert a simple formula/equation into a PP [quoted text clipped - 5 lines] > from what the presenter inputs. If this makes any sense, and you can > help me, please do! OK let me start a bit more simple. Can I do any of this from an existing formatted slide, or should I start from a clean slide? I never heard of VBA before I started trying to do this project today. Please feel free to respond as though to a 2-year old :) Thanks, Andrea (also from Maryland :)) > This is going to require some VBA. First, you will need a way to enter > information onto a slide. This can be done with a control textbox, or it [quoted text clipped - 22 lines] > > from what the presenter inputs. If this makes any sense, and you can > > help me, please do! The normal features of PowerPoint do not have a way to input data during a presentation, and they does not have a way to do something (like calculate) based on something that is input. The link I gave you (http://www.pptfaq.com/FAQ00701.htm) describes some ways to get around the problem of entering the information. The simplest of this is to go to the View menu and choose Toolbars and Control Toolbar. From here, you can draw special textboxes on your slides (called control textboxes). These allow the presenter to type something into the slide. This does not require any VBA (VBA is a scripting language built into PowerPoint that allows you to extend teh capabilities of PowerPoint). However, you not only want to enter information, you also want to use that information on later slides. This does require VBA. If you have never heard of VBA, then this project might be a bit more than you can handle, but it is not very difficult with a little VBA knowledge. To get started, you might look at: Where can I learn more about VBA programming in PowerPoint? http://www.pptfaq.com/FAQ00032.htm --David SignatureDavid M. Marcovitz Microsoft PowerPoint MVP Director of Graduate Programs in Educational Technology Loyola College in Maryland Author of _Powerful PowerPoint for Educators_ http://www.PowerfulPowerPoint.com/ > OK let me start a bit more simple. Can I do any of this from an > existing formatted slide, or should I start from a clean slide? I [quoted text clipped - 31 lines] >> > the data from what the presenter inputs. If this makes any sense, >> > and you can help me, please do! I'll give it a shot. And I told the boss man this is over my head, he understands cause it's over his too :) Thanks for your help! Maybe I'll invest some time learning VBA, looks like it could be a real asset to me in the future. Andrea > The normal features of PowerPoint do not have a way to input data during > a presentation, and they does not have a way to do something (like [quoted text clipped - 55 lines] > >> > the data from what the presenter inputs. If this makes any sense, > >> > and you can help me, please do!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.