Changing Picture Based on Drop-Down in Excel

preview_player
Показать описание
Populate a picture based on selection from a dropdown in this easy 3 step video
Рекомендации по теме
Комментарии
Автор

Not using images but this should work for a template range I have named. Will see if it works, great job on the video and appreciate your making it

marcuse
Автор

Yes but can it all be done in one cell. For example youre using K5 as your dropdown list cell but showing images in M6. Can you use K5 as the list AND display images in K5. So after you select "Davey Jones" in the list cell K5 populates with the image?

CoolIHandIMatt
Автор

Hello and thank you for this quick and helpful video. I am encountering a problem. In step 3, after inserting the random picture unfortunately clicking the image doesn't allow me to write the =Change_Picture. Any ideas why's that?

i-alex