+ Reply to Thread
Results 1 to 5 of 5

Image that can scroll like an iframe

  1. #1
    Registered User
    Join Date
    03-27-2017
    Location
    No
    MS-Off Ver
    Yes
    Posts
    30

    Image that can scroll like an iframe

    I have a map that I want to use as an image

    It is very large.

    I want it to fit in a frame with a range of cells A1:J16 (about 1/4 the workbook)

    However, I want it zoomed to 100%, that is that it stays original size, and be able to scroll the image. (Like an iFrame)

    If possible, I want to be able to pan to a specific section when I click a button

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

    Re: Image that can scroll like an iframe

    One way is to use the camera tool to create a linked picture.
    Then change the range of cell that the image is linked too.

    The example uses named ranges to store start end end row/column values in order to create a dynamic range.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    03-27-2017
    Location
    No
    MS-Off Ver
    Yes
    Posts
    30

    Re: Image that can scroll like an iframe

    Wow! This is perfect! Andy, you sir are gold.

  4. #4
    Registered User
    Join Date
    03-27-2017
    Location
    No
    MS-Off Ver
    Yes
    Posts
    30

    Re: Image that can scroll like an iframe

    I've been trying to recreate your magic, but found no luck.
    I have placed the map on a second sheet. numbered axis accordingly.
    created a linked picture on first sheet, added scrollbar, and numbers that move with scrollbar....
    But my map doesnt pan.
    How do I link the scroll bar to the correct image coordinates?

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

    Re: Image that can scroll like an iframe

    The numbering on the map sheet is only for reference.

    The scroll bars are linked to the MAP_ROW_START and MAP_COL_START cells.
    The MAP_ROW_END and MAP_COL_END cells are start positions minus cells width/height of image
    picture should be linked to named range MAP_VIEW

    Without seeing what you have done it is hard to say why it's not working.

+ 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. Scroll Image and pan.
    By misc.v in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2017, 06:59 AM
  2. [SOLVED] Floating Text Box / Image when you scroll
    By murray83 in forum Excel General
    Replies: 6
    Last Post: 03-15-2017, 03:29 PM
  3. Adding scroll feature in an image that appears on a userform
    By adamstarr12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2014, 02:08 PM
  4. Click in Image with iframe
    By magushi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2014, 11:08 AM
  5. VBA Iframe Src Redirect
    By vbaguy33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2013, 12:19 PM
  6. Change image using scroll bar
    By andrewmaroul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2012, 10:24 AM
  7. Scroll image across screen
    By Chard in forum Excel General
    Replies: 1
    Last Post: 09-22-2007, 03:11 PM

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