#1
|
|||
|
|||
how do i insert a image using syntax not drop down
What is the syntax to insert a picture? I do not want to insert it via drop downs i want a simple formula that =if(b2="y", insert picture <name>)
I have 9 different images that are png. if i have all 9 have "y" that would show all of them at once in the same place. Thanks |
#2
|
||||
|
||||
For example:
Code:
ActiveSheet.Shapes.AddPicture Filename:="your path & name", _ LinkToFile:=False, SaveWithDocument:=True, Left:=0, Top:=0, Width:=Application.InchesToPoints(1), Height:=Application.InchesToPoints(1.5)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert drop down calendar | baes10 | Excel Programming | 4 | 08-14-2018 04:42 PM |
Image as Placeholder (Drop Zone) | Yonz | Word VBA | 0 | 10-03-2017 08:56 AM |
Drop Cap/Insert Picture | Laugh012750 | Drawing and Graphics | 1 | 07-08-2014 05:57 PM |
Insert Picture v. Drop Cap | Laugh012750 | Word | 1 | 07-08-2014 03:07 PM |
Background image vs. insert image | lilaria | PowerPoint | 0 | 04-18-2011 08:45 AM |