Results 1 to 6 of 6

Thread: Please help with vb dropdown list

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Location
    florida
    Posts
    7

    Question 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 ?

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    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

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Location
    florida
    Posts
    7

    Re: Please help with vb dropdown list

    Quote 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

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    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

  5. #5

    Thread Starter
    New Member
    Join Date
    Jun 2005
    Location
    florida
    Posts
    7

    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

  6. #6
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Please help with vb dropdown list

    see other thread again

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