View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mette Mette is offline
external usenet poster
 
Posts: 5
Default Userform - placing

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