2 Way Depedant Dropdown(UserForm) in Excel

[AJ0HN]

Hi,

So I am trying to make a UserForm with 2-way Dropdown.

I have a list of players, listed with group, and if part-time or full-time that appears on Sheet 1 like so:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Player
[/TD]
[TD]Group
[/TD]
[TD]FT/PT
[/TD]
[/TR]
[TR]
[TD]Player 1
[/TD]
[TD]U16
[/TD]
[TD]Full Time
[/TD]
[/TR]
[TR]
[TD]Player 2
[/TD]
[TD]U16
[/TD]
[TD]Part Time
[/TD]
[/TR]
[TR]
[TD]Player 3
[/TD]
[TD]U18
[/TD]
[TD]Full Time
[/TD]
[/TR]
[TR]
[TD]Player 4
[/TD]
[TD]U21
[/TD]
[TD]Full Time
[/TD]
[/TR]
[TR]
[TD]...
[/TD]
[TD]...
[/TD]
[TD]...
[/TD]
[/TR]
</tbody>[/TABLE]

I want on my UserForm to have 2 Dropdowns.

1: Age Group (named drpGroup)

2: Part Time/Full Time (named drpFTPT)

3: Player Name (named drpName)

I have created the 3 Dropdown boxes on UserForm, what code do I need to enter to make it function like requested.

FYI the list of players is in a Excel Table, and named TBL_Players.

Regards,

Ashley