Counter of amount of selections from list

[Robin121]

Hi guys,
I'm looking for a macro that presents a list consisting of data from another worksheet in the same workbook.
I would then like to be able to count and post the result of the counter in yet another cell of the sheet, every time the selection is chosen.
Thanks so much for your help or directions.

 

[Fluff]

Think we'll need a bit more info

Please remember, we cannot see your workbook & we are not mind-readers

 

[Robin121]

Of course; sorry about that...here goes:

it's about a sportsgame:
sheet A contains teams with a number of lists containing countries and their player names;
sheet B has 2 buttons which can be pressed when someone scores; 1 for each team. I wrote a working macro that keeps score; the adjacent field shows the result of the counter; and I added a score-reset button.
Now I would like to extend this macro so that, when I push a score button, it shows a list of player names of that particular team first. I then select the name of the scoring player and a field in sheet A keeps track of the number of times that player has scored. When I sort this list descending, I will be able to show topscorers per country, to later call on these figures and present them on sheet B. Then the list of names disappears from the screen and the score is updated.
Hope this helps..

 

[Fluff]

I'm afraid that doesn't help very much.
Can you please post the code code that you have. Along with what your data looks like.
In my signature there is a link to some tools that will help you to post data to the thread.