How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I am looking to set up a text box for a picture to be inserted

Customer Question

I am looking to set up a text box for a picture to be inserted in on my excel document. I am hoping the box can auto size the picture into it when its inserted. Can you give me step by step instructions on how to do this?

Thanks
Sue
Submitted: 3 years ago.
Category: Microsoft Office
Expert:  John D replied 3 years ago.
Hi,

Try this sample file with the attached image

Attachment: 2013-01-07_185335_2_files.zip



When you extract the files make sure you save them both in the same folder, then open the Excel file, resize your text box to your preferred size and click the Go! button

Also make sure you have your macros enabled so the macro can run

Let me know if this works for you so I can send you the file final file with the code


Expert:  John D replied 3 years ago.
If the picture is getting distorted when inserted in a certain size of text box I can send you another version where the picture ratio is preserved so it does not get distorted