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).