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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:43 PM.