Consulting

Results 1 to 6 of 6

Thread: Solved: "Traffic Light" Status Report

  1. #1
    VBAX Newbie
    Joined
    Mar 2005
    Posts
    3
    Location

    Solved: "Traffic Light" Status Report

    I'm trying to create a high-level Project Report to show the current status of various strands of the project.

    What I would like to have is a number of "traffic lights" on a single slide against the headline topics / project stages with the ability to click on any of the traffic lights and select red, amber or green to show the status of that particular element.

    Is this a step too far for PowerPoint? Should have said - using PP2003


  2. #2
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    Hi and welcome to VBAX

    It doesn't sound like a step too far to me, if I understand correctly...
    You could to use a shape's "Action Settings" to run a macro. (right click a shape then select "Action Settings") The macro could then set the colour of the shape. Although undocumented, the shape clicked can be passed as an argument to the macro.
    Using action settings only works when you're in slideshow view - I don't think you'll be able to get a click event going in normal slide view.

    There's an example attached. Is that what you mean?
    K :-)

  3. #3
    VBAX Newbie
    Joined
    Mar 2005
    Posts
    3
    Location
    Thanks for your help - close enough to what I wanted, so I will go with this.

    I will close this thread and come back with any further questions as I stumble across them!

    Don't seem to be able to close the thread - any clues?
    Last edited by turnern2; 04-11-2006 at 06:25 AM.

  4. #4
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    There's a problem with marking a thread as "solved" at the moment, so I've done this for you.

  5. #5
    I made an account, just to see the allegedly attached file... Thx for nothing :*

  6. #6
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Sorry you're disappointed in not finding a file from a 15 year old thread.


    If you explain what you want to do and politely ask for an example, you might have better luck
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Posting Permissions

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