question

ScottMurphy-8026 avatar image
0 Votes"
ScottMurphy-8026 asked DSPatrick edited

Can someone tell me the macro code for this?

I would like to make a Eurovision style leaderboard in E98858-picture1.pngxcel that updates the position of items on the leaderboard as the score is typed.

For example:

Country Flag is in B2 to B14 and E2 to E14
Country Name is in C2 to C14 and F2 to F14
Country Score is in D2 to D14 and G2 to G14

I want the leaderboard to position the countries in order from highest to lowest as the scores are typed in, so that the highest scoring country is positioned in B2 (Flag), C2 (Name), and D2, (Score), and the lowest scoring country is positioned in E14 (Flag), F14 (Name), and G14 (Score).

For a visual representation, please see attached image.

Can anyone tell me the correct macro code to input and how to do this?


office-vba-dev
picture1.png (104.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers