Insert picture placeholder in spreadsheet

usatraveler · #1 01-29-2016, 09:43 AM

Trying to create a spreadsheet where there is a single picture box that you can click on and select a picture that you have recently taken and it will size down to fit that box.
I can come close with SmartArt but there is not just a single box option. The choices are more complex then what I need.
I know I can insert a picture directly but I want to simplify the process for the end user to click on the box and then choose a picture to go into that object box.

It should be very simple but I am missing something.

Thanks

macropod · #2 02-01-2016, 03:50 AM

If you insert an Active-X image control and position/size it where you want the picture to go, you could use a macro like:

Code:

Private Sub Image1_Click()
With Application.Dialogs(xlDialogInsertPicture)
  If .Show = True Then
    With Selection.ShapeRange
      .Width = Image1.Width
      .Height = Image1.Height
      .Top = Image1.Top
      .Left = Image1.Left
    End With
  End If
End With
End Sub

usatraveler · #3 02-02-2016, 06:42 AM

That did the trick. I appreciate your help with this.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
slidemaster view, insert placeholder greyed out	banjodaddy	PowerPoint	1	01-14-2016 03:28 PM
"Insert Picture\Link to File..." embeds picture	sinz54	Drawing and Graphics	1	09-29-2013 06:31 PM
SlideMaster: Date Placeholder, Footer Placeholder, Slide Number Placeholder?	tinfanide	PowerPoint	1	04-05-2013 10:37 AM
Picture Placeholder problem	lerningdaily	PowerPoint	2	03-04-2013 02:09 AM
Picture "Placeholder" in Word 2003	legodan	Drawing and Graphics	1	10-31-2011 02:18 AM