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: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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 01:07 AM.