Thread: How to open a form to a better place?
View Single Post
 
Old 04-06-2017, 04:23 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
I don't think that's the place to put it.
Here's what I did for my 1600x900 screen.

In frmHarvest properties change StartUpPosition to 0 - Manual
In the forms code module add
Code:
Private Sub UserForm_Activate()
    Me.Top = Application.Height - frmHarvest.Height - 50
    Me.Left = Application.Width - frmHarvest.Width - 40
End Sub
play with the -50 and -40 for adjustment.
Reply With Quote