VSTO & .NET & Excel

March 23, 2010

Preserve Size and Location of Windows Forms – Part II

Filed under: .NET & Excel — Dennis M Wallentin @ 8:12 pm

The first post in this mini series can be found here:
Preserve Size and Location of Windows Forms – Part I

Here I will discuss how we must do to preserve the size and location of Windows Forms that are part of managed COM Add-in and VSTO Add-ins. We can still use the approach that was discussed in the first post however we need to add the following code into the closing event of the Windows Form:

    Private Sub frmMain_FormClosing(ByVal sender As Object, _
                                    ByVal e As  _
                                    System.Windows.Forms.FormClosingEventArgs) _
                                    Handles Me.FormClosing


    End Sub

As already pointed out by Mike Rosenblum; if we use C# then we need to save the settings for the Windows Form also in standalone applications.

Just for fun I made some additional solutions where we grab a Windows Form’s location and size and use them:

Imports System.Text

    Private Sub btnLocation_Click(ByVal sender As System.Object, _
                                  ByVal e As System.EventArgs) _
                                  Handles btnLocation.Click

        Dim LocationStrBuilder As New StringBuilder("XY         : " + _
                                                    Me.Location.X.ToString + _
                                                    " " + _

        LocationStrBuilder.Append("TopLeft: " + _
                                   Me.Top.ToString + _
                                   " " + _


        LocationStrBuilder.Append("Desktop: " + _
                                  Me.DesktopLocation.X.ToString + _
                                  " " + _


    End Sub

    Private Sub btnSize_Click(ByVal sender As System.Object, _
                              ByVal e As System.EventArgs) _
                              Handles btnSize.Click, btnSize.Click

        Dim SizeStrBuilder As New StringBuilder("Height: " + _

        SizeStrBuilder.Append("Width  : " + _


    End Sub

    Private Sub btnDesktop_Click(ByVal sender As System.Object, _
                                 ByVal e As System.EventArgs) _
                                 Handles btnDesktop.Click

        'Of course, each variable can be set on its own.
        Me.SetDesktopBounds(x:=Me.Location.X + 10, _
                            y:=Me.Location.Y + 5, _
                            width:=Me.Width + 50, _
                            height:=Me.Height + 100)
    End Sub


That’s all for now and in an upcoming post I will discuss anchoring and docking controls on Windows Forms.

Kind regards,


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: