HI ,
I here by attaching file i need a macros to fetch the image in Sheet "Shape" Column "C" , based on "Shape Code" in column "B" , i need the output in Sheet name "Calculation" Column "T" by considering the lookup value in Column "J".
Early i have done this using name manager but i the draw back is i have to create many reference .
Note :
If this can be one by formula it also helps me
Find the attached sheet
With Regards,
P V Ravi Kumar
Hello
to keep this active
hello
any help
Hi
all need help .. lookup for image in excel either by Code or formula
Punnam
Last edited by Punnam; 04-30-2019 at 03:16 AM.
HI,
Help
Punnam
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi
Sintek how use this code i have created module and saved this but nothing happening .
Error Message : "Cant Execute code in break mode"
Punnam
Administrative Note:
Regarding the frequent bumping of this thread, we don't expect you to bump threads more than once in every 24 hours. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi sintek,
It works good but need some more correction
1) i have to first Enter all the Shape code and then i have to execute the Macros , This part is good
2) But if code is executed more than once i am getting duplicate images
3) Can i get the code executed dynamically only for individual rows for those which shape is entered .
Punnam
Code gets placed in std module and run from command button...see attached...
Aligw.
Sorry for the bumping i will take care and stop sending reminder .
Punnam
If you want the picture inserted as you type the code in each cell then put this in Sheets("Calculation") Module
Please Login or Register to view this content.
Sintek,
I first really appreciate your patience to help , the second code works like magic , i am having few more amendments hope you could help me
1) if I re enter the shape code, the current shape is over lapped on my previous one, instead of that let the previous shape get deleted
2) The sheet "Calculation" is proto type i may need more than 20 sheets based on the requirement : so do i need to copy the code to all the sheet ? or do we have any alternative
3) A small delete macros to clean a particular sheet before i use it again .
With Regards,
Punnam
CommandButton on sheet to clear shapes...Solves #3
This code in ThisWorkbook.Module...Solves #1 & #2Please Login or Register to view this content.
Please Login or Register to view this content.
hi,
One more issue when i am trying to insert a row, all the macros are stopped and asking for debug .
With Regards,
Punnam
Try this...
just afterPlease Login or Register to view this content.Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
So this code will not work am i correct
Punnam
I have deleted the shape code accidentally and since then the macros stopped working attached the PPT error message
Punnam
When Copied to another work book
Formula:Please Login or Register to view this content.
Punnam
Virus in your powerpoint file...
I have no idea what you are referring to now...Post 14 & 16 solved all your points...
@Punnam: What do you expect someone here to do,You want US to guess what the error message is?stopped and asking for debug
Press Yes to debug and see what's the error,
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
So...put the code back...I have deleted the shape code accidentally and since then the macros stopped working attached the PPT error message
@sintek: aren't you asking too much
keebellash,
My knowledge to Macros or VBA is Minute , what i can do is copy and run check this is am capable of .
sintek
I have transferred the code to another work book with same sheet name and information unfortunately the code was not working and showing Run time error "1004" ..
i will Share the Image
Punnam
Last edited by Punnam; 05-02-2019 at 03:43 AM.
After replacing the code i have to close it and reopen it again to activating the macros
sintek
I think i am asking too much thanks for help i will work on the sheet you have made for me it will solve all problem .
With Regards,
Punnam
@ Keebellah
I remember when I had no Excel knowledge...
Rather share the file...i will Share the Image
Hi
Find the file
Same here, but ...
I see you added drop downs...So not the same as previous workbook
Also...INCREASE your Row heights so that the pics fit in otherwise code can't find pic to delete as it does not fit in the cell
Please Login or Register to view this content.
Last edited by sintek; 05-02-2019 at 04:43 AM.
Sintek,
Thanks for helping me in preparing this sheet you work is amazing
With Regards,
Punnam
.........................................
Thanks.gif
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks