ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do set/ fix the opening position of a user form (https://www.excelbanter.com/excel-discussion-misc-queries/243940-how-do-set-fix-opening-position-user-form.html)

DataBoy

How do set/ fix the opening position of a user form
 
I have a 2007 Excel macro which displays a user form for input. I want the
user form to always be located over cells A1:D6 of the worksheet when it is
opened by the macro, regardless of the Excel window size and/or Excel window
location, how can this be done? (the issue I am encountering is when users
have multiple screens displaying data and Excel is being displayed on (for
example) screen two, the user form opens and positions itself in the upper
left corner of the left most screen and users cannot find the userform).


All times are GMT +1. The time now is 07:35 AM.

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