I am in the process of building a userform to make changes to golf teams.
Right now I have a combobox (TeamsComboBox) that contains a list of 50 golf
team names and a blank listbox (TeamListBox) below it. When the user clicks
on a name in the combobox I want that team's golfers to show up in the
listbox for editting. The names in the list of teams are in A2:A51. A2 is
named TEAM1, A3 is named TEAM2, etc. Each team has its own named array that
contains their 10 golfers (i.e. TEAM5GOLFERS). I plan to use the cell name of
the team selected to concatenate into "TEAM5"&"GOLFERS" to be able to bring
the team's golfers (i.e. TEAM5GOLFERS) into the listbox for editing. Am I
making any sense?

Thanks for any suggestions.
--
Jim T

Private Sub TeamsComboBox_Click()
With Me
.TeamsListBox.RowSource = Worksheets("Sheet1") _
.Range(.TeamsComboBox.Value & "Golfers").Address(, , , True)
End With
End Sub


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jim Tibbetts" <(E-Mail Removed)> wrote in message
news:7EE10228-60C9-4C13-89B3-(E-Mail Removed)...
>I am in the process of building a userform to make changes to golf teams.
> Right now I have a combobox (TeamsComboBox) that contains a list of 50
> golf
> team names and a blank listbox (TeamListBox) below it. When the user
> clicks
> on a name in the combobox I want that team's golfers to show up in the
> listbox for editting. The names in the list of teams are in A2:A51. A2 is
> named TEAM1, A3 is named TEAM2, etc. Each team has its own named array
> that
> contains their 10 golfers (i.e. TEAM5GOLFERS). I plan to use the cell name
> of
> the team selected to concatenate into "TEAM5"&"GOLFERS" to be able to
> bring
> the team's golfers (i.e. TEAM5GOLFERS) into the listbox for editing. Am I
> making any sense?
>
> Thanks for any suggestions.
> --
> Jim T

That'll work. Thanks Bob.
--
Jim T


"Bob Phillips" wrote:

> Private Sub TeamsComboBox_Click()
> With Me
> .TeamsListBox.RowSource = Worksheets("Sheet1") _
> .Range(.TeamsComboBox.Value & "Golfers").Address(, , , True)
> End With
> End Sub
>
>
> --
> ---
> HTH
>
> Bob
>
> (change the xxxx to gmail if mailing direct)
>
>
> "Jim Tibbetts" <(E-Mail Removed)> wrote in message
> news:7EE10228-60C9-4C13-89B3-(E-Mail Removed)...
> >I am in the process of building a userform to make changes to golf teams.
> > Right now I have a combobox (TeamsComboBox) that contains a list of 50
> > golf
> > team names and a blank listbox (TeamListBox) below it. When the user
> > clicks
> > on a name in the combobox I want that team's golfers to show up in the
> > listbox for editting. The names in the list of teams are in A2:A51. A2 is
> > named TEAM1, A3 is named TEAM2, etc. Each team has its own named array
> > that
> > contains their 10 golfers (i.e. TEAM5GOLFERS). I plan to use the cell name
> > of
> > the team selected to concatenate into "TEAM5"&"GOLFERS" to be able to
> > bring
> > the team's golfers (i.e. TEAM5GOLFERS) into the listbox for editing. Am I
> > making any sense?
> >
> > Thanks for any suggestions.
> > --
> > Jim T
>
>
>