Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2018, 10:56 AM
renderbydesign renderbydesign is offline how do i insert a image using syntax not drop down Windows 7 64bit how do i insert a image using syntax not drop down Office 2013
Novice
how do i insert a image using syntax not drop down
 
Join Date: Jun 2017
Posts: 3
renderbydesign is on a distinguished road
Default 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
Attached Images
File Type: jpg insertpic.jpg (153.9 KB, 5 views)
File Type: jpg insertpic2.jpg (123.1 KB, 5 views)
Reply With Quote
  #2  
Old 10-23-2018, 04:38 PM
macropod's Avatar
macropod macropod is offline how do i insert a image using syntax not drop down Windows 7 64bit how do i insert a image using syntax not drop down Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,465
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
how do i insert a image using syntax not drop down Drop Cap/Insert Picture Laugh012750 Drawing and Graphics 1 07-08-2014 05:57 PM
how do i insert a image using syntax not drop down 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft