ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Move Form to edge of chart window (https://www.excelbanter.com/excel-programming/441478-move-form-edge-chart-window.html)

Jason Falzon[_2_]

Move Form to edge of chart window
 
I am using some vba in excel to display different forms in different sheets.

Workbook has one data entry sheet with a dedicated form. This I manage to
select as I have info on the screen resolution even if it changes and by
selecting a particlar cell I manage to move this form relative to this cell.

The problem is that I have 2 other sheets that are both chart windows.

For each chart window I have a dedicated form that shows up whenever I
switch to that particular sheet.

My problem lies witht the positioning of these 2 forms, since that chart
windows have no cells to refer to.

Is there a way to incorporate screen resolution script (ALREADY HAVE), and
chart window properties to move form to top right hand corner?



All times are GMT +1. The time now is 01:41 AM.

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