View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Falzon[_2_] Jason Falzon[_2_] is offline
external usenet poster
 
Posts: 13
Default 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?