View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_7_] Duncan[_7_] is offline
external usenet poster
 
Posts: 18
Default Userform - placing

On 23 Sep, 11:24, Mette wrote:
Hi Corey

Thanks for your answer.

I have tried this:

Load UserForm1
UserForm1.StartUpPosition = 0
UserForm1.Left = -30
UserForm1.Top = 20

UserForm1.Show

but nothing is changed. The UserForm still pop up in the middle of the
screen. What am I doing wrong?

"corey" skrev:

Select the form in VB, and Change the StartUpPosition to manual.


Then place the required position in the LEFT=


Corey....
"Mette" wrote in message
...
Hi,


I have created a userform which startups when the file opens.


I would like a specific placement different from the standard.


How do I have it to startup with its left corner in A18 for instance?


Mette


That code works fine. Where have you put it?