Consulting

Results 1 to 2 of 2

Thread: Open URL from drop down in PowerPoint

  1. #1
    VBAX Newbie
    Joined
    Jan 2014
    Posts
    1
    Location

    Open URL from drop down in PowerPoint

    Hi

    I want to create a drop down list in PowerPoint where the user can open a selected URL.
    For example can the drop down list contain two options:
    1. Apple - opens apple.com
    2. Microsoft - opens microsoft.com

    I have managed to populate the drop down list, but not launch a browser based on the chosen option.

    The slide will contain target KPIs for a company and the drop down list will contain the different plants. Based on the choice you can open a web based monitoring tool for that specific plant.

    Can someone help me?

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    Assuming this is a ComboBox (and is named ComboBox1) try right click > View Code and add this

    Private Sub ComboBox1_Change()
    Dim strLink As String
    Select Case Me.ComboBox1.ListIndex + 1
    Case Is = 1
    strLink = "http://www.apple.com"
    Case Is = 2
    strLink = "http://www.microsoft.com"
    End Select
    ActivePresentation.FollowHyperlink strLink
    End Sub
    Last edited by John Wilson; 01-14-2014 at 04:33 AM.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Tags for this Thread

Posting Permissions

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