Hello
Please Login or Register to view this content.
I am new to excel and have a spreadsheet that pulls a picture from a file when you change the contents of the cell. I would like to be able to have this cell use a vlookup function to control its contents thereby changing the picture when an alternate cell is changed. So far I have this but it does not work. Any help would be greatly appreciated.
Please Login or Register to view this content.
Last edited by KraftWorker; 10-22-2012 at 06:30 PM.
If (updatedCel) <---- there's a problem, for sure. Not sure if that is causing your problem, but it won't help. =)
Its my inexperience that is causing me not to know how to designate the changed cell. I also changed the code drop downs to be this
Private Sub Worksheet_Calculate()
Mine, too.Originally Posted by KraftWorker
I am just starting to learn VBA. So, like I said, I'm not sure what is causing the issue, but 'updatedCell' is mistyped in your IF statement. So that is definitely something to correct before proceeding.
- Vince
Ok, I fixed the spelling correction and also tagged the code properly. Thanks for the help so far. I'm still not getting the code to work yet.
I have changed my code and it is partially working.
What I really need now is for someone to help me figure out how to duplicate the outcome to multiple cells, Any takers
New 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