Results 1 to 4 of 4

Thread: VBA newbie, help required please *RESOLVED* (ish)

  1. #1

    Thread Starter
    Hyperactive Member Simon Caiger's Avatar
    Join Date
    Aug 2000
    Location
    Rugby, England
    Posts
    377

    VBA newbie, help required please *RESOLVED* (ish)

    I have dabbled with VBA in Excel before but now I need to do some more complex things in PowerPoint.

    I would be grateful if somebody could answer these simple (I hope) questions :

    1) As certain slides are loaded, I need to run some code. Sometimes this is immediately the slide is shown, other times it will be some period of time after the slide is shown. I have sussed how to create a timer but what I need to know is there some kind of Slide_Load event?
    I am currently using a CommandButton on the slide but I would really like to automate the process.

    2) UserForms seem to be some kind of VB Form object. Do these get displayed on the PowerPoint slide? If so, what is the display method (Show?).

    3) Is there a PictureBox control available? Either to be displayed on a UserForm or preferrably on the slide.

    Thanks in advance
    Last edited by Simon Caiger; May 19th, 2003 at 04:22 AM.
    Simon Caiger

    Documentation is like sex; when it's good, it's very, very good, and when it's bad, it's better than nothing.

  2. #2
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Haven't got a clue with the first one, powerpoint like word is extremely crap when it comes to events completely different to excel or vb for some reason. Here's a couple of links I have in my favourites, I dunno if any are going to be usefule for you:

    http://msdn.microsoft.com/library/de...powerpoint.asp
    http://msdn.microsoft.com/library/de...ionChanged.asp
    http://officerone.tripod.com/vba.html

    Q2 - A userform is very much like a standard vb form & it' an extra window sitting on the screen rather than embedded into a slide & I think the syntax is userformnam.show or userformnam.visible = true the same with a vb form.

    Q3 - Nope, you have an image control, or you can download or make a custom picture usercontrol which you could add into the project, but powerpoint only supports the image control.

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details

  3. #3

    Thread Starter
    Hyperactive Member Simon Caiger's Avatar
    Join Date
    Aug 2000
    Location
    Rugby, England
    Posts
    377
    Although your answers to my questions were disappointing
    Thanks for the reply Alex

    Looks like you are pretty restricted with what you can do with VBA in PowerPoint.
    Simon Caiger

    Documentation is like sex; when it's good, it's very, very good, and when it's bad, it's better than nothing.

  4. #4
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Yeah god knows why MS have done this - Excel is fine - each worksheet has events which you can call on as normal, if you try the same in powerpoint, your stuffed!

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width