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
Microsoft Office version
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.
Using 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
Set the value of the NamedRange control to Hello World.
Me.message.Value2 = "Hello world"this.message.Value2 = "Hello world";
Using 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
Retrieve the range at cell A1 on Sheet1 and set the value to Hello World.
Dim rng As Excel.Range = Me.Application.Range("A1") rng.Value2 = "Hello world"Excel.Range rng = this.Application.get_Range("A1", missing); rng.Value2 = "Hello world";
See Also
Tasks
How to: Interact with Windows Forms
Walkthrough: Collecting Data Using a Windows Form
Concepts
Global Access to Objects in Visual Studio Tools for Office Projects
The Variable missing and Optional Parameters in Office Solutions