Running Excel VBA in Powerpoint

[rikapple]

I have a Macro with 2 buttons. Ideally I am looking to run this Macro within PowerPoint.

PowerPoint is just to run a video in the background with the Macro on top. I have that part working , but I am unable to get the macro to run correctly or the buttons to work correctly.

Is there anything I need to do to ensure this works?

Many thanks in advance

Steph

 

[jkpieterse]

Post your code, otherwise we won't be able to help

 

[rikapple]

Public Stopflag As Boolean
Sub runnum()
Do While Not (Stopflag)
Range("F4") = Range("f4") + 1
If Range("f4") > 2000 Then Range("F4") = 0
' call your subroutine here instead of the last two lines of code
DoEvents
Loop

End Sub

Sub Stoprun()
Stopflag = True
End Sub
Sub Startrun()
Stopflag = False
Call runnum
End Sub

 

[jkpieterse]

Well, these statements are excel-specific, so they will not run on Powerpoint:

Range("F4") = Range("f4") + 1
If Range("f4") > 2000 Then Range("F4") = 0

you could try this:

Sub runnum()
dim i as Long
Do While Not (Stopflag)
i = i + 1
If i > 2000 Then i = 0
' call your subroutine here instead of the last two lines of code
DoEvents
Loop

End Sub

 

[rikapple]

This is the file I have so far, all I am trying to achieve is have the names rotating around on the first button press and then stop on the second press. The issue I am also having is the excel sheet will not display until after I exit the presentation. I would like the randomised names showing when the start button is pressed.

I have it working in Excel and everything is the same so unsure what has gone wrong. Any comments much appreciated.

Link Here is a link to my file

Kind regards

Stephanie

 

[jkpieterse]

Well, for one, there is no code behind the two buttons so it makes perfect sense that nothing is happening. Also, where would these names you want to display come from? They are not in the powerpoint file apparently.

 

[rikapple]

Well, for one, there is no code behind the two buttons so it makes perfect sense that nothing is happening. Also, where would these names you want to display come from? They are not in the powerpoint file apparently.

The excel sheet page 1. It displays page 2. That's why I am asking for help!

 

[jkpieterse]

I have working code, but it isn't very reliable when in presentation mode. See the OneDrive folder.

 

[rikapple]

I have working code, but it isn't very reliable when in presentation mode. See the OneDrive folder.

Ian, thank you for this been away from my desk for a few days but will check it out now