|
-
Jun 17th, 2005, 09:47 AM
#1
Thread Starter
New Member
Please help with vb dropdown list
hey everyone !
i am newbie at VB coding
i am creating a ppt presentation - i am trying to create a drop down list that will display the names of teams.
when a user clicks on a team name - they will taken to a particular page in the ppt presentation.
i would like to know
1 - how to add team names to the drop down list
2 - how to navigate to a particular slide number after clicking on a particular team name in the drop down list
can anyone help me ? or possibly direct me in the right direction to solve this problem ?
-
Jun 17th, 2005, 10:23 AM
#2
Re: Please help with vb dropdown list
here is how to add to a combobox
ComboBox1.AddItem mystring
sorry don't use power point so can't help with the other
try recording a macro, to do what you want, then edit the code to suit
pete
-
Jun 17th, 2005, 10:48 AM
#3
Thread Starter
New Member
Re: Please help with vb dropdown list
 Originally Posted by westconn1
here is how to add to a combobox
ComboBox1.AddItem mystring
sorry don't use power point so can't help with the other
try recording a macro, to do what you want, then edit the code to suit
pete
do you mean like this ?
Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem mystring
End Sub
-
Jun 17th, 2005, 10:54 AM
#4
Re: Please help with vb dropdown list
not quite, you would have to put in the userform activate event, or a command button click event
where mystring is the name you want to add, you willl have to have a line for each name
pete
-
Jun 17th, 2005, 11:44 AM
#5
Thread Starter
New Member
Re: Please help with vb dropdown list
do you mean like this ?
Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "Haines City Rattlers"
ComboBox1.AddItem "Lake Wales Steelers"
ComboBox1.AddItem "Frostproof Bulldogs"
ComboBox1.AddItem "Poinciana Predators"
ComboBox1.AddItem "Osceola Panthers"
ComboBox1.AddItem "Metro Rams"
ComboBox1.AddItem "Oak Ridge Pioneers"
ComboBox1.AddItem "Bishop Moore Hornets"
ComboBox1.AddItem "Lakeland Chargers"
ComboBox1.AddItem "Lakeland Storm"
ComboBox1.AddItem "Lakeland Falcons"
ComboBox1.AddItem "Lakeland Bulldogs"
ComboBox1.AddItem "Mulberry Panthers"
ComboBox1.AddItem "Winter Haven Wolverines"
End Sub
-
Jun 17th, 2005, 11:45 AM
#6
Re: Please help with vb dropdown list
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|