A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Powerpoint
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

PPT VBA - Clicking on non-existent textbox?



 
 
Thread Tools Display Modes
  #11  
Old March 6th, 2005, 08:55 PM
David M. Marcovitz
external usenet poster
 
Posts: n/a
Default

Are you using a Mac or Windows? In Windows, the VBA Editor will prompt you
with suggestions for what comes next. You can scroll through the list of
available methods and properties. Every time you hit dot on the keyboard a
new list comes up of available options.

Also, as bad as the help is, it can also give you a list of available
properties and methods. Once you get to the right page (Shape, for example),
there is link to properties and another to methods. This is very helpful.

--David

David Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

"Zigzag" wrote:

Hi Kathy,

Welcome back to 100 Aker Wood.

About OO - Think about a light switch.


I think I've given a slightly misleading impression regarding my approach to
OO. I understand, roughly, how it operates and I do have certificates in
Javascript and Java. What I can't get to grips with is the need to know what
objects exist and what can and can't be done by built-in procedures.
For instance, I want to add an effect - what methods are available and on
which object(s)?
I want to create a textbox in runtime and make it clickable to do something.
Honest to God, Kathy, I didn't know where to start. I tried the vba help and
tried to extrapolate from examples, all to no avail. "Think, think, think".

Given the popularity of OO I can only resign myself to the fact that I have
a short circuit somewhere which refuses to identify the logic behind these
languages. "Oh, bother".
With the 'old' languages you had a number of commands that you applied in a
logical sequence to achieve what you wanted - read, manipulate, write.
Now, you can do all sorts - if you know what's available, or so it seems to
me.

Unless you are really stuck on doing this using VBA, there is an easier
way. Create one "More" button for each set of text that is longer than one
box. Give it an appear animation. Drag that appear animation to just after
the triggered animation for the first text box. Now, when you click the
trigger for the text box, both the text box and the more box appear. (Oh,
and don't forget to add it's exit to the trigger for making the second
text box disappear. But you know that already.)


Have already tried this Kathy. The problem lies in the fact that I might
have more than one "More" box at the same location on the slide even if only
one is showing. PPT seems to 'lock' the clickability of the top box even if
you change the zorder in runtime.

Regards

Mr. Sanders



  #12  
Old March 6th, 2005, 09:03 PM
David M. Marcovitz
external usenet poster
 
Posts: n/a
Default

That brings back memories. I don't know if I have ever met anyone else who
has even heard of SNOBOL. If I look hard enough, I might even find an old
SNOBOL book in my office from a class I took many years ago. Sorry about this
message that breaks the STRING of programming language puns.
--David

David Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

"Steve Rindsberg" wrote:

Monsieur Ziggie, bon soir.

This bit of appears to be VBA has a SNOBOL's chance of helping you do the deed,
you pascal (how appropriate at this time of year) rascal. Go forth. Blaise
new trails!


  #13  
Old March 6th, 2005, 09:15 PM
Zigzag
external usenet poster
 
Posts: n/a
Default

Hi Austin,

Thanks for the info, looks like a long read.

I'll have a read at leisure and see if something clicks (pun intended).

Cheers

Zig


  #14  
Old March 6th, 2005, 10:23 PM
Kathy J
external usenet poster
 
Posts: n/a
Default

What you have to do is to stack them in the right order, which is actually
the first one to be clicked on top, then the next one, then the next one. I
have an example I can send you off newsgroup that shows you what I mean.
Unknot the address to contact me.

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Zigzag" wrote in message
...
Hi Kathy,

{clippage.....}

Have already tried this Kathy. The problem lies in the fact that I might
have more than one "More" box at the same location on the slide even if
only one is showing. PPT seems to 'lock' the clickability of the top box
even if you change the zorder in runtime.

Regards

Mr. Sanders




  #15  
Old March 6th, 2005, 10:26 PM
Austin Myers
external usenet poster
 
Posts: n/a
Default

Read? No, commit to memory! eg

If you want drop me an email and I can send you a help file that has just
the PPT stuff and is geared specifically to give you all the events,
properties, and methods available. (A handy reference to be sure.)


Austin Myers
MS PowerPoint MVP Team


"Zigzag" wrote in message
...
Hi Austin,

Thanks for the info, looks like a long read.

I'll have a read at leisure and see if something clicks (pun intended).

Cheers

Zig



  #16  
Old March 6th, 2005, 10:28 PM
Austin Myers
external usenet poster
 
Posts: n/a
Default

But making puns is such a BASIC thing...



"David M. Marcovitz" wrote in
message ...
That brings back memories. I don't know if I have ever met anyone else who
has even heard of SNOBOL. If I look hard enough, I might even find an old
SNOBOL book in my office from a class I took many years ago. Sorry about

this
message that breaks the STRING of programming language puns.
--David

David Marcovitz
Author of _Powerful PowerPoint for Educators_
http://www.loyola.edu/education/PowerfulPowerPoint/

"Steve Rindsberg" wrote:

Monsieur Ziggie, bon soir.

This bit of appears to be VBA has a SNOBOL's chance of helping you do

the deed,
you pascal (how appropriate at this time of year) rascal. Go forth.

Blaise
new trails!



  #17  
Old March 6th, 2005, 10:32 PM
Kathy J
external usenet poster
 
Posts: n/a
Default

Got another answer for you:
Simple record of sending an item to back shows that you can use:
ActiveWindow.Selection.ShapeRange.ZOrder msoSendToBack
to send an element to the back. I bet that you can figure out how to make it
do the ordering you need... (After all, if I could...)

--
Kathryn Jacobs, Microsoft MVP PowerPoint and OneNote
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint answers at http://www.powerpointanswers.com
I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

"Zigzag" wrote in message
...
Hi Kathy,

Welcome back to 100 Aker Wood.

About OO - Think about a light switch.


I think I've given a slightly misleading impression regarding my approach
to OO. I understand, roughly, how it operates and I do have certificates
in Javascript and Java. What I can't get to grips with is the need to know
what objects exist and what can and can't be done by built-in procedures.
For instance, I want to add an effect - what methods are available and on
which object(s)?
I want to create a textbox in runtime and make it clickable to do
something. Honest to God, Kathy, I didn't know where to start. I tried the
vba help and tried to extrapolate from examples, all to no avail. "Think,
think, think".

Given the popularity of OO I can only resign myself to the fact that I
have a short circuit somewhere which refuses to identify the logic behind
these languages. "Oh, bother".
With the 'old' languages you had a number of commands that you applied in
a logical sequence to achieve what you wanted - read, manipulate, write.
Now, you can do all sorts - if you know what's available, or so it seems
to me.

Unless you are really stuck on doing this using VBA, there is an easier
way. Create one "More" button for each set of text that is longer than
one box. Give it an appear animation. Drag that appear animation to just
after the triggered animation for the first text box. Now, when you click
the trigger for the text box, both the text box and the more box appear.
(Oh, and don't forget to add it's exit to the trigger for making the
second text box disappear. But you know that already.)


Have already tried this Kathy. The problem lies in the fact that I might
have more than one "More" box at the same location on the slide even if
only one is showing. PPT seems to 'lock' the clickability of the top box
even if you change the zorder in runtime.

Regards

Mr. Sanders




  #18  
Old March 6th, 2005, 10:35 PM
Kathy J
external usenet poster
 
Posts: n/a
Default

I C what you mean. 'Ada join in here sooner or later. Couldn't let all this
language Smalltalk go by too long.


"Austin Myers" wrote in message
...
But making puns is such a BASIC thing...



  #19  
Old March 7th, 2005, 12:16 AM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

There's only one thing you can say to that:

Gol Forth Solo Mantis AndF Multi-pascal.


O dear. I've if not created, at least abetted and encouraged a monster.
g


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


  #20  
Old March 7th, 2005, 12:16 AM
Steve Rindsberg
external usenet poster
 
Posts: n/a
Default

In article , David M. Marcovitz
wrote:
That brings back memories. I don't know if I have ever met anyone else who
has even heard of SNOBOL.


Having heard of it is about all I can lay claim to. Oh, I may have read an article
about it in Byte magazine, remember that?

[If he fesses to that, he's older than he looks, folks]

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Textbox, web browser control, and Unicode (got cutoff) Mark Johnson General Discussion 0 February 12th, 2005 01:08 AM
Setting the Control source of a textbox to a query based on the valueof another textbox on the same form Joey Running & Setting Up Queries 1 January 26th, 2005 03:35 AM
textbox to normal text Jack Sons New Users 16 December 5th, 2004 03:44 PM
textbox used as report parameter jh Setting Up & Running Reports 4 October 21st, 2004 06:59 PM
textbox formatting problem jeffrey c Powerpoint 4 August 21st, 2004 10:09 AM


All times are GMT +1. The time now is 12:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.