+ Reply to Thread
Results 1 to 2 of 2

Inserting Picture into Comment and re-sizing to fit chosen picture

  1. #1
    Registered User
    Join Date
    04-16-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    1

    Inserting Picture into Comment and re-sizing to fit chosen picture

    Hi All!

    I have set up a macro to create a comment and insert a background picture. The issue is that I cannot figure out how to make the comment box the size of the original picture. Since the inserted picture will be different each time, I need it to resize automatically. I have been searching for answers all afternoon, but none of the resizing code I've seen address this situation. Here's what I have so far:

    Please Login or Register  to view this content.
    Any suggestions?

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Inserting Picture into Comment and re-sizing to fit chosen picture

    try below
    Please Login or Register  to view this content.
    if you want to hide the cell comment if image is big then use below line before end sub
    Please Login or Register  to view this content.
    Last edited by hemesh; 04-17-2014 at 01:55 AM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] sizing picture same picture in multiple sheets macro clean up
    By martinez77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2013, 10:14 PM
  2. Inserting a Picture Link into a Comment
    By bungaree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2013, 04:09 AM
  3. Inserting a comment/text box to a picture (excel 2007)
    By LouisLingard in forum Excel General
    Replies: 4
    Last Post: 07-19-2012, 07:39 AM
  4. Excel - Inserting, Naming, sizing and then copying a picture
    By geoffrey2312 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2011, 03:53 AM
  5. Inserting a picture into comment macro
    By jarednz in forum Excel General
    Replies: 1
    Last Post: 09-07-2011, 02:24 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1