Listbox selection

U

ub

Hi
I have 4 sets of data that contain names of 4 different team members.
What I want to do is that when user selects TEAM A in the first list box the
2nd list box that has names of the team memebsr should show the names of the
TEAM A
The TEAM data is in cells
TEAM A A2:A16
TEAM B B2:B16
TEAM C C2: C16
TEAM D D2 to D16

Please advise how to write a VBA code and also where should this code be
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLookup or Macro? 0
list items from one table in another table based on value in first table 2
Rank based on 2 categories 6
Formula for seperating data 2
Need V-Lookup to Return A Row, Not Just Single Value 2
Problem with formula for finding last greater than/less than or equal to value 2
if(isna(match formula 8
Rota system 2

Top