View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Display position of Userform

Hi Andy,

Try using the Top and Left properties of the Userform, e.g.:

'===========
Private Sub UserForm_Activate()
With Application
Me.Top = 0
Me.Left = 525
End With
End Sub
'<<===========

Change the values to suit.


---
Regards,
Norman


"AndyRoo" wrote in message
...
I want a userform to display at the top right side of the screen when it is
launched.

The userform StartUpPosition property gives me 4 options, none of which
will
do what I want. Is there any code I can write that will show the form
where
I want it to go?

I know it is possible to drag it over but I'd prefer it to start off where
I
want it to be.