View Single Post
 
Old 04-06-2017, 12:25 PM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default How to open a form to a better place?

Here is a macro that opens a form which appears in the center of my computer screen.

Code:
Sub OpenHarvestForm()
 
 Application.WindowState = xlMinimized
 frmHarvest.Show
 Application.WindowState = xlMaximized
 ActiveWorkbook.Sheets("GrpRecords").Activate
 
End Sub
My question is, can I add something to this code, so that my form automatically pops up in the bottom-right side of the window?
Reply With Quote