MsgBox position once open

[ipbr21054]

Hi,
General question for when the MsgBox opens & is shown on the screen is the default setting to open middle of screen, Is it possible to have it paced more towards the top.

Reason i ask is some of my customers in a drop down box are just out of sight & the bottom of the screen thus having to scroll to see the last 3 names.

Allowing the user to specify where the MsgBox should be seen of the screen would fix this.
Is this possible ?

Thanks

 

[davesexcel]

It maybe easier to create an additional userform that you can pop up at specific location.

 

[ipbr21054]

Hi
Let’s assume it’s called userform1
Can you advise code please to sock it more towards the top of the screen.

if you can advise the piece I need to edit so I can move it about.
Thanks.

 

[davesexcel]

You can determine where the userform pops up in the userform initialize event.

Private Sub UserForm_Initialize()
    '-------------------------------
    Me.StartUpPosition = 0
    Me.Top = Application.Top + 20
    Me.Left = Application.Left + Application.Width - Me.Width - 200
   
    '-------------------------------
End Sub

 

[ipbr21054]

Perfect many thanks works well