• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Flag Corresponding to the selected country

S

S P P

Member
Good Morning!

I select a country in column A its corresponding flag is displayed in column C on the same line
 

Attachments

  • SPP Flag Corresponding to the selected country.xlsm
    36.2 KB · Views: 6
I need a code that captures the flag from the flag country worksheet to the Country worksheet.
example
country worksheet
A10 C10
USA Flag of the flag country worksheet B3
 
S P P
Why do You ... need ... to have/get own collection of pictures of flags?
... instead something like those links would give.
 
Still vague so just well elaborate at least an example with details & references, step by step, in order there is nothin' to guess …​
​
 
I made an approximate example of what I need
 

Attachments

  • SPP Flag Corresponding to the selected country1.xlsm
    25.6 KB · Views: 1
As I was expecting a complete informative explanation rather than another attachment …​
But the last attachment shows a different naming convention so if I have written a code according to the initial attachment​
it could not work anymore with this last attachment !​
​
So can you name the flags as per the country name like in the initial attachment, easier to code ?​
​
 
I already got it this way

I expected to achieve using VBA
 

Attachments

  • SPP Flag Corresponding to the selected country2.xlsm
    136.4 KB · Views: 10
Well done !​
​
So again without any answer to my question and as your last attachment well works without any VBA procedure so why any VBA way ?​
​
 
You must log in or register to reply here.
Back
Top