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, 03:45 PM

Cyberseeker Cyberseeker is offline

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

Office 2010 32bit

Advanced Beginner

Join Date: Jun 2016

Posts: 44

Hi Logit,

Can't get through to your first link. The stack article is related but I cant write it into my code. I tried (shown here in green) but it never worked.

Code:

Sub OpenHarvestForm()
 
 Application.WindowState = xlMinimized
 frmHarvest.Show
 Application.WindowState = xlMaximized
 Application.Right
 Application.Bottom
 ActiveWorkbook.Sheets("GrpRecords").Activate
 
End Sub

Can you suggest a line or two?

« 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:16 AM.