Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to reference an ACTIVEX control using VBA?

739 views
Skip to first unread message

Gato_de_Botas

unread,
Feb 27, 2009, 12:55:05 PM2/27/09
to
I have some activex controls in some slides (not userforms). I want to make
an INITIALIZE procedure to clean the TEXTBOX from the first slide in the
presentation.

I tried:
ActivePresentation.Slides(6).TextBox1.Value = "" and also tried
ActivePresentation.Slides(6).Shapes("TextBox1").Value = ""

but none of them is working.

The textbox are in the range of slides 6 to 18, one textbox in each of it.
The user fills the textbox while the presentation is runing; it is necessary
an initialize procedure to clean the textbox at the begining of the
presentation.

John Wilson

unread,
Feb 27, 2009, 2:31:01 PM2/27/09
to
Try

ActivePresentation.Slides(6).Shapes("TextBox1").OLEFormat.Object.Value = ""
--

john ATSIGN PPTAlchemy.co.uk
Custom vba coding and PPT Makeovers
Free PPT Hints, Tips and Tutorials
http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html

Gato_de_Botas

unread,
Feb 27, 2009, 7:43:00 PM2/27/09
to
Thanks John! It's working perfectly!
Also I used the expression:

For i = 6 To 20
ActivePresentation.Slides(i).Shapes("TextBox1").OLEFormat.Object.Value = ""
Next i

to get all slides that have the TextBox1.

0 new messages