Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
With Application; Me.Top = ...
With Application
Me.Top = 0 Me.Left = 625 End With Just hoping to advance my knowledge.. An old post of Norman Jones gave the above solution to initial positioning of a userform on the screen using a With structure - works great. I use 'With Structures' but this code is in a form that I've not come across yet so it caught my eye. I tried to educate myself by typing out the instruction without the With Structure, eg: Application.me.top etc but I'm obviously missing a trick. Can anyone advise what the code looks like without the 'With'? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute a Macro from one excel Application to another Application | Excel Programming | |||
difference application.quit & application.close | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |