![]() |
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