Programmatically display a string in a worksheet cell

This example demonstrates how to display text in a cell programmatically. To display text in cell, use either a NamedRange control or a native Excel range object.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

Use a NamedRange control

This example uses a NamedRange control named message. The control must be added to a document-level customization at design time. The following code must be placed in a sheet class, not in the ThisWorkbook class.

To display text in a NamedRange control

1. Set the value of the NamedRange control to Hello World.

   C#

   this.message.Value2 = "Hello world";
   

   VB

   Me.message.Value2 = "Hello world"
   

Use a native Excel range

The following code creates a new range programmatically and then assigns a value to it.

To display text in an Excel range

1. Retrieve the range at cell A1 on Sheet1 and set the value to Hello World.

   C#

   Excel.Range rng = Globals.Sheet1.Range["A1"];
   rng.Value2 = "Hello world";
   

   VB

   Dim rng As Excel.Range = Globals.Sheet1.Range("A1")
   rng.Value2 = "Hello world"
   

Related content

• Walkthrough: Collect data using a Windows form
• Troubleshoot Office solutions
• NamedRange control
• Global access to objects in Office projects
• Optional parameters in Office solutions