Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-29-2016, 09:43 AM
usatraveler usatraveler is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2016
Posts: 3
usatraveler is on a distinguished road
Default Insert picture placeholder in spreadsheet

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
Reply With Quote
  #2  
Old 02-01-2016, 03:50 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,392
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-02-2016, 06:42 AM
usatraveler usatraveler is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2016
Posts: 3
usatraveler is on a distinguished road
Default Thank You

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

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft