ExcelBanter - View Single Post - Userform

Mette

Thanks! It works fine.

"Mike H" skrev:

hi,

Right click your userform, View code and paste this in. Play with the
numbers to position it where you want.

Private Sub UserForm_Activate()
With UserForm1
.Top = Application.Top + 300 'Top - Bottom
.Left = Application.Left + 25 'Left - Right
End With
End Sub

Mike

"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