+ Reply to Thread
Results 1 to 5 of 5

Click to Zoom image VBA

  1. #1
    Registered User
    Join Date
    09-08-2015
    Location
    Baku
    MS-Off Ver
    2016
    Posts
    38

    Click to Zoom image VBA

    Hello, can someone help me , I need image to zoom, when you click on image.
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 10-11-2015 at 10:31 PM. Reason: Added Code Tags

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Click to Zoom image VBA

    Hi Akbaruu,

    See the file associated with post #2 in the following thread which enlarges a chart (similar to enlarging an image): http://www.excelforum.com/excel-char...ml#post4037479

    If you need additional help, please upload a sample file that contains a sample image, and describe how you want the size to change.

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Lewis

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Click to Zoom image VBA

    Hello Akbaruu,

    Here is another method you might be able to use. Copy and paste the code below into a new VBA Module in your workbook.

    Assign the macro ZoomOnClick to each picture. The first click will zoom the picture to 150% of its original size. The second click will zoom to 200% and the the third click will return the picture to its original size.

    VBA Module Code
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    09-08-2015
    Location
    Baku
    MS-Off Ver
    2016
    Posts
    38

    Re: Click to Zoom image VBA

    hey bro, it says item with specified name not found error

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Click to Zoom image VBA

    Hello Akbaruu,

    Post a copy of your workbook.

+ 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] Double click zoom, unzoom
    By Ajohn403 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2015, 07:48 PM
  2. Click gif image in IE via VBA
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2015, 03:02 AM
  3. User form Image zoom in-Out on move over move
    By lulupatel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2015, 06:21 PM
  4. Zoom plot in image control box present in the userform
    By HinaSha in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-04-2014, 12:26 AM
  5. how to zoom in a picture in an image control by mouse selecting an area?
    By xujingwei_bgp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-28-2010, 09:14 AM
  6. Image Invisible. Click
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2008, 04:15 AM
  7. Replies: 1
    Last Post: 12-09-2005, 09:40 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