View original (French)

Incorporate a simple calculation into a PowerPoint.

DADOU2A Posted messages 3 Status Member -  
DADOU2A Posted messages 3 Status Member -
Hello,

I have a problem with PowerPoint 2013.
I'm not sure if this is possible, but I'm giving it a shot :)

I am a teacher, and I am looking for a way for my students to enter their age and heart rate on a slide. I want to use a simple calculation (sum and product) so that the result of the operation displays in a text box.

I can do this in Excel, but I would like to know if it is possible to integrate it into PowerPoint without having to open Excel.

I hope my explanations are clear...

Thank you in advance for your responses.

1 answer

  1.
    cs_Le Pivert Posted messages 8437 Status Contributor 730
     
    Hello,

    here is an example in VBA:

    http://www.cjoint.com/c/FJkjVYVwZhQ

    --
    @+ The Woodpecker
    2
    1. DADOU2A Posted messages 3 Status Member
       
      Thank you very much, that's exactly it!
      A silly question, I think: in the file, I can only change the left Textbox. To be able to work on the addition Textboxes, do I need to add something to the VBA code?
      Thanks again for your help.
      0
      1. cs_Le Pivert Posted messages 8437 Status Contributor 730 > DADOU2A Posted messages 3 Status Member
         
        You can put a button, which you take from the tools. Then double-click on this button and set the adapter macro, removing the other macro.

        If there's a problem, I will send another example. But it's better to try to get familiar with macros.

        See you later, Le Pivert.
        0
    2. DADOU2A Posted messages 3 Status Member
       
      Alright, thank you so much for your help, I'm trying to get familiar with macros and VBA code but for a beginner it's not easy.
      Anyway, thanks again!
      0