Walkthrough: Displaying Text in a Text Box in a Worksheet Using a Button

Article
02/04/2013

This walkthrough shows the basics of using buttons and text boxes on Microsoft Office Excel worksheets, and how to create Excel projects using Office development tools in Visual Studio. To see the result as a completed sample, see the Excel Controls Sample at Office Development Samples and Walkthroughs.

Applies to: The information in this topic applies to document-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

During this walkthrough, you will learn how to:

Add controls to a worksheet.
Populate a text box when a button is clicked.
Test your project.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Working with Settings.

Prerequisites

You need the following components to complete this walkthrough:

An edition of Visual Studio 2010 that includes the Microsoft Office developer tools. For more information, see [Configuring a Computer to Develop Office Solutions](bb398242\(v=vs.100\).md).

Microsoft Office Excel 2007 or Excel 2010.

Creating the Project

In this step, you will create an Excel Workbook project using Visual Studio.

To create a new project

Create an Excel Workbook project with the name My Excel Button. Make sure that Create a new document is selected. For more information, see How to: Create Office Projects in Visual Studio.

Visual Studio opens the new Excel workbook in the designer and adds the My Excel Button project to Solution Explorer.

Adding Controls to the Worksheet

For this walkthrough, you will need a button and a text box on the first worksheet.

To add a button and a text box

Verify that the My Excel Button.xls workbook is open in the Visual Studio designer, with Sheet1 displayed.
From the Common Controls tab of the Toolbox, drag a TextBox to Sheet1.
From the View menu, select Properties Window.
Be sure that TextBox1 is visible in the Properties window drop-down box and change the Name property of the text box to displayText.
Drag a Button control onto Sheet1 and change the following properties:

Property

Value

Name

insertText

Text

Insert Text

Property	Value
Name	insertText
Text	Insert Text

Now write the code to run when the button is clicked.

Populating the Text Box when the Button is Clicked

Each time the user clicks the button, Hello World! is appended to the text box.

To write to the text box when the button is clicked

In Solution Explorer, right-click Sheet1, and then click View Code on the shortcut menu.

Add the following code to the Click event handler of the button:

Private Sub insertText_Click(ByVal sender As Object, ByVal e As System.EventArgs) _
    Handles insertText.Click

    Me.displayText.Text += "Hello World! "
End Sub

private void insertText_Click(object sender, EventArgs e)
{
    this.displayText.Text += "Hello World! ";
}

In C#, you must add an event handler to the Startup event as shown below. For information on creating event handlers, see How to: Create Event Handlers in Office Projects.
```
this.insertText.Click += new EventHandler(insertText_Click);
```

Testing the Application

You can now test your workbook to make sure that the message Hello World! appears in the text box when you click the button.

To test your workbook

Press F5 to run your project.
Click the button.
Confirm that Hello World! appears in the text box.

Next Steps

This walkthrough shows the basics of using buttons and text boxes on Excel worksheets. Here are some tasks that might come next:

Deploying the project. For more information, see Deploying Office Solutions.
Using check boxes to change formatting. For more information, see Walkthrough: Changing Worksheet Formatting Using CheckBox Controls.

Share via