Hi All,
If i have different images/pictures in each sheets. What is the best code to use to call or insert that image that was in the sheet that my code called and insert or paste it into the userform?
for example
in sheet1 i have an image of a tree
in sheet2 i have an image of a boy
my code called sheet2 and in the userform it should paste the image of the boy
and if my code calls sheet1 it should paste the image of the tree.
Last edited by saikong051; 08-19-2014 at 06:28 AM.
see my testfile attached
if problems attach please a samplefile with some images and the userform
Last edited by patel45; 08-18-2014 at 12:43 PM.
If solved remember to mark Thread as solved
Hi Patel,
I've attached a sample file for this.
if i choose Team2. it should paste the team2 picture.
see attached
Thank you so much patel45.Rep added.
Hi Patel,
Im getting an error "Subscript out of range" when i apply the code to my project.
did you rename all images with sheet name ? have a look on my example, each image has the same name as the sheet
Last edited by patel45; 08-19-2014 at 12:30 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks