Reference an activex control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi .
If I have a label on a slide how can i reference it in vba.
Eg an oval on a slide rotates how do i get the label to give its rotation?
 
Items from the control toolbox are referenced in VBA via their slide
numbers. For example, the first label you add to slide 7 will be
referenced via Slide7.Label1

The content of the label is the Caption. You can change teh caption with
Slide7.Label1.Caption = "Whatever you want"

Next, you need to get the rotation of your Oval, which can be done
something like this:

Slide7.Label1.Caption = ActivePresentation.Slides(7).Shapes(2).Rotation

assuming that your oval is shape #2 on slide 7.

--David
--
David 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/
 
Sorry David I just tried it and it only showed 0 is there away to have it
update say with the degrees of rotation.
Cheers
 
You're probably referencing the wrong shape, or your not running the
macro after the shape has been adjusted. For example, if your shape is
not the #2 shape, then Shapes(2) won't give you the right rotation. You
might want to give the shape a name and use that instead of the number
(see Example 8.7 on my site for naming shapes).

The other issue I mentioned was running the macro. Note the macros don't
necessarily run themselves so you have to figure out when you want to
trigger the macro to update the label.

--David

--
David 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 David,
The shape is correct.
If I stop the slideshow and change it's rotation it is correct.
I am not sure how to write the macro to update whilst the show is running.
or if it is possible.
Cheers
 
How are you rotating the shape during the slide show? Do you have a macro
that does that? Or I am misunderstanding what you are doing?
--David

--
David 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/
 
Back
Top