Hi There, Bit new to this but can anyone help me with some solutions to allow me to selcet a picture from a drop down list?
Hi There, Bit new to this but can anyone help me with some solutions to allow me to selcet a picture from a drop down list?
Hello GERZO,
Welcome to the Forum.
I am not sure how your WorkBook is setup, or what the layout looks like, but you could use the attached sample WorkBook as a start.
Change it the way you like.
Also see the "Please consider" note at the bottom of this post.
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] .
Hello Winon,
How to change the pictures attached file.
I want to add more my pictures.
Thanks in advance for your help.
Regards
@ turist,
Upload a WorkBook with all your pictures, and I will sort it out for you.
@ Winon
My dear friend.
If the OP has 200(or more) pictures?
I believe that it's better to show to him(her) HOW can do it and not you to solve it for him(her).
In any case, turistsee in this link how you can do this WITHOUT VBA. Using only formulae.
http://www.youtube.com/watch?v=CEM0pp5SjMU
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
See Post #5 from Fotis1991.
Hello turist,
Then have a look at the sample WorkBook in Post #2, and the link Fotis1991 has provided in Post #5 to do it without using VBA.I want to learn how to place the pictures to the file.
As Fotis1991 said , "it's better to show me HOW can I do it myself".
I am sure you will come right on your own if you study these two ways of getting it done.
Good luck!
Thanks dear Winon.
I solved your attached file in Post#2 (Where code is : Me.Pictures.Visible = False)
When changed as "Me.Pictures.Visible = True" , all pictures are shown on the page.
Now I can manage my file.
Thanks again for your guidance.
Hello turist,
Good. I knew that you will get it right!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks