View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default With Application; Me.Top = ...

the me is not necessary, you can just use
with application
..top=0
..left=625
end with

I use the me's as well. So just typing it without the with:
application.top=0
application.left=625

the with just lets you set multiple properties without retyping application.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

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