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:50 PM

Logit

Windows 10 How to open a form to a better place?

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

Private Sub UserForm_Initialize()
    Me.StartUpPosition = 0
    Me.Top = Application.Top + Application.Height - Me.Height
    Me.Left = Application.Left + Application.Width - Me.Width
End Sub

« 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 04:08 PM.