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:

Player	Group	FT/PT
Player 1	U16	Full Time
Player 2	U16	Part Time
Player 3	U18	Full Time
Player 4	U21	Full Time
...	...	...

<tbody>
</tbody>

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