PDA

View Full Version : Open URL from drop down in PowerPoint



Hkaas
01-13-2014, 12:00 PM
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?

John Wilson
01-14-2014, 04:10 AM
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