How to open a form to a better place?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to open a form to a better place?

FAQ

Thread Tools

Display Modes

04-06-2017, 04:23 PM

NoSparks

Windows 7 64bit How to open a form to a better place?

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS word 2007, capital letter after number (1. place turn to 1. Place)	enzo321	Word	1	10-23-2016 06:19 AM
Paste from one page to another doesnt place in the same place	MrShhh	Visio	0	09-21-2016 05:47 AM
editing a number/text at one place and changes taking place wherever it appears	anurag.butoliya	Word	1	06-14-2014 06:27 PM
Creating Form, inserting text box - getting things to stay in place?	SHC	Word	4	08-15-2013 09:18 AM
when open doc formatting all over the place	Anne	Word	1	11-30-2011 02:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:34 PM.