Hi All,
Needs assistance in Renaming an image inside a sheet so that i can let the code call it and paste in my project.
Please see the attached file.
in the teamform, Image1 box, that's where the image should show in each team. Different logo per team.
Last edited by saikong051; 08-28-2014 at 12:09 PM.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi xladept,
may i know where to put that code?
so sorry, i'm still not that good when it comes to coding.
and how can make sure that the picture or Logo of the TEAM name that's showing in the form is also showing in the Image1 box?
Directions for running the routine(s) just supplied
Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select "Module" from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
Hi saikong051 and Orrin,
Try the following two Macros:
a. The first one renames the Image on the Active Sheet to 'PictureTeamLogo'.
b. The second opens up the UserForm for the Active Sheet and inserts the image (details in the code).
LewisPlease Login or Register to view this content.
Hi Saikong,
You wanted to name the image - did you run my code?
@Lewis - Thanks for that, I guess we interpreted the request differently - well as long as no dynamic requirements evolve
Saikong
why a new thread ? you let the first http://www.excelforum.com/excel-prog...r-picture.html practically unsolved,
you could manually rename images
Clic on image, change name on top left field
Last edited by patel45; 08-20-2014 at 05:41 AM.
If solved remember to mark Thread as solved
Hi All,
Sorry just got back from long vacation leave.
xladept: i've tried your code.. i think it renamed the picture but when i try to use the code where it will paste the picture in a userform, it does not work.
LJMetzger: i'll try to understand your code first then try it. i'll get back once i have a result.
patel45: i don't see that Change name tool in my excel. I'm using Excel 2010. and sorry, this one has a different file / project that's why i created a new thread.
if someone wants to view the whole file. please pm me your email address.. i'll forward it to you.. i can't attach the file here since it has more bytes than the allowed size that can be posted.
Hi saikong,
We (I) often use the dropbox to convey the larger files. Thanks for the rep!
Hi xladept,
You're welcome.
by the way, we are not allowed to have zip / dropbox here in the office.. i'll try to send it in my personal email and zip it in my laptop.
Hi All, Hi patel-- i was able to find that rename part for images.. hehe Sorry took me a long time.. i was able to finish my project.. it now shows the picture in the image1 form..
used this code.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks