+ Reply to Thread
Results 1 to 3 of 3

Retrieve image in cell comment

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Retrieve image in cell comment

    Hi

    Can anyone pls help with the following problem? I want to know I can assign an image in a cell comment to an image control in a userform. I can't seem to find any literature on how to extract the image stored in the comment and assign it to the image control on the userform.

    Is this possible? The image must surely reside somewhere?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Retrieve image in cell comment

    This uses Stephen Bullen's PastePicture code to grab the comment shape
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-14-2011
    Location
    South Africa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Retrieve image in cell comment

    Thanks a mil Andy!

    Works like a charm. I had that code but couldn't get it to work.
    I did however have problem with image quality though but sorted that out by first resizing the comment before adding the picture.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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