Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

How to: Display a String in a Worksheet Cell

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

For more information, see Features Available by Application and Project Type.

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.

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

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

    this.message.Value2 = "Hello world";

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

To display text in an Excel range

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

    Excel.Range rng = this.Application.get_Range("A1", missing);
    rng.Value2 = "Hello world";

Community Additions

© 2015 Microsoft