|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. ArchiveDisclaimer|
How to: Send Values to Worksheet Cells
Some code examples in this topic use the this or Me keyword or the
You can send a value to a cell in a worksheet by assigning the value to the
To send a value to a named range of a worksheet
Create acontrol on cell A1 of
Sheet1, and assign a string value to the Value2 property.
Compiling the Code
This code must be placed in a sheet class, not in the
The following condition causes an exception:
The worksheet exists and is read-only (class).
User input can include information that is potentially malformed, malicious, or not valid. Always check that the values that a user enters conform to the requirements for your application before using the values. For more information, see