Display VBA String Result in slide

[Yogi_Bear_79]

I would like to have a slide in a show run VBA code when the slide appears.
The code will retunr a string, and the string needs to be shown on the
slide.

It would preferable if the string can be displayed in something taht can be
pre-formatted. For example, I would like to maybe make the background black,
and the sting to be displayed in RED, with a chosen Font and size.

I should be OK, with the VBA, I'm just not sure how to display the results
on the slide

 

[Steve Rindsberg]

I would like to have a slide in a show run VBA code when the slide appears.
The code will retunr a string, and the string needs to be shown on the
slide.

It would preferable if the string can be displayed in something taht can be
pre-formatted. For example, I would like to maybe make the background black,
and the sting to be displayed in RED, with a chosen Font and size.

I should be OK, with the VBA, I'm just not sure how to display the results
on the slide

Does this really need to happen when the slide appears or can it be at any time
BEFORE the slide appears?

For example, a button on another slide could trigger a macro like:

With ActivePresentation.Slide(42).Shapes("MyWeirdLittleTextBox")
.TextFrame.TextRange.Text = "Hi. I'm different now."
End With

 

[Yogi_Bear_79]

Does this really need to happen when the slide appears or can it be at any
time
BEFORE the slide appears?

For example, a button on another slide could trigger a macro like:

With ActivePresentation.Slide(42).Shapes("MyWeirdLittleTextBox")
.TextFrame.TextRange.Text = "Hi. I'm different now."
End With

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

It can happen anytime during the show, just so what slide "x" is displayed
the data is up to date. Unfortunately this is not an interactive show, so it
will need to be automated somehow.

 

[Steve Rindsberg]

It can happen anytime during the show, just so what slide "x" is displayed
the data is up to date. Unfortunately this is not an interactive show, so it
will need to be automated somehow.

Then you'll probably need to create and install an add-in that traps and
responds to the event fired when the presentation starts:

Make PPT respond to events
http://www.rdpslides.com/pptfaq/FAQ00004.htm