Prev: Userform modal
Next: rewrite code
From: Jason Falzon on 9 Apr 2010 03:18
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?
 | 
Pages: 1
Prev: Userform modal
Next: rewrite code