Writing Code Behind a Control

Writing code behind a control on a document or spreadsheet is not much different from writing code behind a normal Windows Forms control. You can double-click a control and the designer will add a new event handler for the default event on the control in the partial class for the sheet or document you are working on. The only difference is where the event handler is hooked up in the code generated by the designer. In a standard Windows Forms form, the event handler is hooked up in the hidden generated code (form1.designer.cs). In a VSTO code item, the event hook up is generated into the visible user partial class (sheet1.cs rather than sheet1.designer.cs) in the InternalStartup method.

Event handlers can also be generated by using the Events view in the Properties window. In this view, you can double-click an event handler cell to add a default named event handler for an event. Alternatively, you can enter the name of the event handler function you want to use. The event handler hookup code is generated in the same place (InternalStartup) as if you double-clicked on the control. Listing 14-2 shows the code generated when you drop a button on a spreadsheet and then double-click the event handler cell for Click and SystemColorsChanged to generate default event handlers for these events.

Listing 14-2. Default Event Hookup and Handlers Generated by VSTO for a Button's Click and SystemColorsChanged Events

using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using Microsoft.VisualStudio.OfficeTools.Interop.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

namespace ExcelWorkbook1
{
 public partial class Sheet1
 {
 private void Sheet1_Startup(object sender, EventArgs e)
 {

 }

 private void Sheet1_Shutdown(object sender, EventArgs e)
 {
 }

 #region VSTO Designer generated code
 private void InternalStartup()
 {
 this.button1.Click += 
 new System.EventHandler(this.button1_Click);
 this.button1.SystemColorsChanged += 
 new System.EventHandler(this.button1_SystemColorsChanged);
 this.Shutdown += new System.EventHandler(this.Sheet1_Shutdown);
 this.Startup += new System.EventHandler(this.Sheet1_Startup);
 }
 #endregion

 private void button1_Click(object sender, EventArgs e)
 {

 }

 private void button1_SystemColorsChanged(object sender, EventArgs e)
 {

 }
 }
}

 

Events That Are Never Raised for a Control in an Office Document

Not all the events on a Windows Forms control are raised in an Office document. For example, the ResizeBegin and ResizeEnd events are common across all Windows Forms controls (these events are defined on the Control base class) but are never raised on controls on a document or worksheet because of the way the Windows Forms support in VSTO was designed.