Can I dock my form

Topic

New Reply

Hello. (Excel 2003)
Can a VBA UserForm be docked to the right-hand side? Andy.

Reply | Quote

Replies

No…

Reply | Quote

I suppose you could either remove its title bar or use something klunky like:

Code:

Private Sub UserForm_Activate()
    SetPos
End Sub
Sub SetPos()
    With Me
        .Top = 0
        .Left = Application.ActiveWindow.Width - .Width - 5
    End With

End Sub

Private Sub UserForm_Layout()
    SetPos
End Sub

Reply | Quote

This is a bit neater.

Reply | Quote

Thank you. Although I should have mentioned that I wanted to dock it to the right, which is a bit trickier?! Andy.

Reply | Quote

Both versions dock on the right…

Reply | Quote

You can put a userform inside a taskpane using a dll Stephen Bullen has written:
http://www.oaltd.co.uk Look for CTPUserformhost (near top of page)

Reply | Quote