?
Solved

Inserting Image and Text into the same Excel Box

Posted on 2014-01-16
2
Medium Priority
?
288 Views
Last Modified: 2014-01-16
Hello Excel Experts.

I am using Excel 2007 for windows.

I have some cells where I want to insert both text and images.

What is the best method to do this.

Thanks!

Rowby
0
Comment
Question by:Rowby Goren
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39785586
You can't. You cannot put pictures "in" a cell, only "over" it. All pictures "float" on the worksheet. You can position a picture over a cell by setting its Top and Left properties to the Top and Left of the cell. Then you could insert text in any cell including directly above or beneath the picture.

Set p = ws.Pictures.Insert("C:\Sample.jpg")

Set objRng = ws.Range("A2:B5")
With p
   .Top = objRng.Top
   .Left = objRng.Left
   .Width = objRng.Width
   .Height = objRng.Height
End With

ws.Range("A1").Value = "myTop"
ws.Range("B6").Value = "myBottom"
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 39785720
Thanks   That clarifies my confusion!
0

Featured Post

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question