Hello to all,
I have a workbook with a sheet (Flags.xlsx uploaded) containing the country name (A), ISO code (B) and flags (C) (pictures).
On a userform I have a combobox populated with the ISO codes.
I would like to populate an image control on the userform according to the value selected on the combobox.
I have googled around but found no solution.
Can this be accomplished using VBA?
Many thanks for any kind help
Octavio
Hello oteixeira,
Your sample workbook is incomplete. I would suggest you upload a sample workbook, showing us your, userform complete with Code, and exactly where you would like us to assist.
Thank you.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
It would make things simpler if the flags were named as the ISO values. This could easily be done with code.
But I don't know if that is allowed.
The inherent weakness of the liberal society: a too rosy view of humanity.
Hello to all,
I’m now uploading the macro-enabled file with the UserForm containing the Combobox and the image control.
My goal is to use the Combobox_Change() event to fill the image control according to the value selected in the combobox.
Many thanks for any kind help.
Octavio
You did not answer my question in Post #3 so this has adapted code I had for a similar workbook.
Hello Jolivanes,
Thanks a million for your help. It works perfectly!
Would buy You a beer if I could
Octavio
No problem. Glad it is what you needed and thanks for letting us know.
Good Luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks