+ Reply to Thread
Results 1 to 4 of 4

Range to Image

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    Netherland
    MS-Off Ver
    2019
    Posts
    2

    Range to Image

    Friend was looking for a way to create a help (manual) in Excel, he wanted to use a Userform to display it.
    To keep it simple, he has put a WordObject on the worksheet in the worksheet.
    The area that covers the Word document is converted to a picture in jpg format, which can be easily loaded into a Userform.image.
    This image is saved in Ms Windows temporary folder, from which the Userform.image can load the image.
    It takes too long to load a WordObject into a Userform every time, and if the help word file is not there, the help will not work.
    Hence, WordObject is embedded in a Worksheet.

    Hope it helps someone. Provided the code with Rem lines. But forgive me if it's crooked English.

    Module Code
    Please Login or Register  to view this content.
    Userform Code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Magoo_NL; 01-20-2021 at 05:48 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Range to Image

    Hi, welcome to the forum.
    What is exactly your question?
    Your file works, but that's not the problem.
    Could you explain it a little more?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    07-31-2019
    Location
    Netherland
    MS-Off Ver
    2019
    Posts
    2

    Re: Range to Image

    Quote Originally Posted by Keebellah View Post
    Hi, welcome to the forum.
    What is exactly your question?
    Your file works, but that's not the problem.
    Could you explain it a little more?
    Hi Keebellah,

    I have no problem, I made something for a friend who could not find this on excel vba forums. and because I thought here more people would like an example, I posted it, did not see any subforum examples here otherwise I would have posted it there

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Range to Image

    Well, thanks, there are is nu specific dub forum but it falls under VBA, and there there quiet a few solutions there.
    Yours needs a little finetuning but it looks good

+ 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. Centering Image in Merged Range
    By saq7792 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-15-2019, 07:10 PM
  2. Fit an image to a range of cells.
    By bartbartbart in forum Excel General
    Replies: 2
    Last Post: 08-02-2017, 02:01 AM
  3. [SOLVED] Select range convert to image
    By dekueb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2015, 03:20 PM
  4. delete image within a certain range
    By OAKLEY in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-31-2014, 04:16 PM
  5. [SOLVED] Copying Active Cell-Row-Range to Other Workbook is pasting an image of copied range
    By jrtraylor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2013, 01:08 AM
  6. Move image to range
    By edwardpestian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2007, 03:39 PM
  7. VBA to display image on a form - image is defined in Range Name
    By Tan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2006, 10:45 AM

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