ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Active chart screen visible coordinates (https://www.excelbanter.com/excel-programming/411234-active-chart-screen-visible-coordinates.html)

RLang

Active chart screen visible coordinates
 
Hi,
Is there a way to programmatically determine the starting or ending
visible portion of an embedded active chart in twips if the chart is larger
than a user's monitor? I have an application including an interactive chart
that imports jpg images based on a user clicking on a chart symbol. By
default, I place the image in the upper left of the chart. If the user has
scrolled towards the bottom of the chart and clicked a symbol, if their
monitor is too small, they then have to scroll back up to view it. I'd like
to programatically check the visible chart portion upon the click event and
place the image on the chart still within the viewable area.

RLang

Active chart screen visible coordinates
 
Nevermind, found activewindow.visiblerange functions.

"RLang" wrote:

Hi,
Is there a way to programmatically determine the starting or ending
visible portion of an embedded active chart in twips if the chart is larger
than a user's monitor? I have an application including an interactive chart
that imports jpg images based on a user clicking on a chart symbol. By
default, I place the image in the upper left of the chart. If the user has
scrolled towards the bottom of the chart and clicked a symbol, if their
monitor is too small, they then have to scroll back up to view it. I'd like
to programatically check the visible chart portion upon the click event and
place the image on the chart still within the viewable area.



All times are GMT +1. The time now is 10:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com